Pivot Chart Legend editing?

  • Thread starter Thread starter srpd
  • Start date Start date
S

srpd

How can I edit the legend in a Pivot Chart in Excel 2007? Or, if thats not
possible, can I edit the data titles in the values field?

Ex: the field is titled Amount Awarded. In the Pivot Field List-Values it is
"Sum of" or "Count of Amount Awarded". How can I edit out "Sum of" or "Count
of" so it doesn't appear in the chart?
 
On your pivot table, edit the data field heading, and change the name. Since
"Amount Awarded" is already reserved as the name of the data, you'll have to
cheat and make the name something like "Amount Awarded " (note the extra
space).
 
It works!
Thank you

Luke M said:
On your pivot table, edit the data field heading, and change the name. Since
"Amount Awarded" is already reserved as the name of the data, you'll have to
cheat and make the name something like "Amount Awarded " (note the extra
space).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
How can I edit the legend in a Pivot Chart in Excel 2007? Or, if thats not
possible, can I edit the data titles in the values field?

Ex: the field is titled Amount Awarded. In the Pivot Field List-Values it is
"Sum of" or "Count of Amount Awarded". How can I edit out "Sum of" or "Count
of" so it doesn't appear in the chart?
Click to expand...

Hi,
After editing pivot field there is message "Pivot Table field name already exists" appears. How to prevent this message.
 
Hey, srpd.

My trick is to leave a space before my actual legend value. For example, I'll change:

"Sum of Pokémon" to " Pokémon"
​
That extra space isn't noticeable by the end user and seems to be effective in preventing the aforementioned error.

Cheers,

~Aleister.
 
Back
Top