PivotChart: Remove "Sum of" Label

[alexisb]

I posted this question in the "Access other topics" forum. It was suggested that I post the question in this forum so I am posting a link to that thread about trying to remove the "sum of" label in PivotCharts.
Thanks,
Alexis
thread181-896193

 

[Zonie32]

If you go into the chart, right click on the Sum Of Data1 button, click Format Pivot Chart Field and under Name, just rename it to Data 1. You will have to put a space between Data and 1 otherwise if you name it Data1, it will say that name already exists, so just add a space. This should work if I understand your problem correctly. Hope this helps if you haven't already figured it out.

 

[alexisb]

Thanks, Zonie32, but I don't see any options to format when I right-click on the button. When I put the mouse over the button, I see "Field Button Sum of Data1" but when I right-click, I only see very basic functionality. I have Access 2002, is it possible this is in Access 2003 only? I have done many queries, including complicated crosstab queries, and I have always been able to format the labels the way I want. I appreciate your help.
Alexis

 

[gwog]

I'm not sure how Pivot Tables work in Access 2002 (i use 97). But in 97 they open in excel. And excel it is pretty easy to change the field name:

Put curser in a cell with data for that field, and then right clicking. You should then see the option "Field Settings".

When that comes up it will have a box by Name that is where you would enter the field name you want to appear. ie. Data 1.

Beware Zonie is correct in that you will have to give it a different name from the original field name but you can accomplish this with a space as Zonie recommended.

Hope that helps.