Pivot Chart Legend editing?

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?
 
L

Luke M

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).
 
S

srpd

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!*
 
B

bhovibasavaraj

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?

Hi,
After editing pivot field there is message "Pivot Table field name already exists" appears. How to prevent this message.
 
Joined
Nov 10, 2015
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top