PivotChart

[jp1987]

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 only show "Sum of 1" as the Series name. I can not get rid of this.

Any ideas on a work around?

 

[umair434]

I had a similar problem and I think this is how I dealt with (did it a while ago).

open the query in pivottable view instead. Select "sum of 1" and then click Property sheet, and then go to second tab (which should be captions).

try this. I'm sure experienced users of this forum will be able to provide you more help, if this doesn't work

 

[umair434]

and if you want to change add the chart title and/or edit axis, then open the click property sheet on the pivot chart. under the first tab (which should be general), you should see "ADD" on screen's middle left. click that to add titles