So I have created a PivotChart from a query.
All the data is displayed fine and everything works as it should.
However, The quey headers simply state a sequence like "1" or "2".
I have this plotted, and wish to have the series name. However, this is where it turns interesting as it will...