View Single Post
  #4   Report Post  
nylanderson nylanderson is offline
Junior Member
 
Posts: 1
Default

Hi there,

I am quite new to the Pivot world and am looking for exactly this, i.e. to change the legend name in the Pivot chart.

However, when following the advice here it only works as long as I have keep the selected fields the same. In other words, once I deselect a field and then select it again it the legend name again appears as "Sum of..."

Am I missing something?

Thanks!


Quote:
Originally Posted by Luke M View Post
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!*


"srpd" wrote:

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?