Can I change data chart labels?

  • Thread starter Thread starter ~D~
  • Start date Start date
D

~D~

This is for a test so here is my example:

I created a pivot data chart and the items were:

drum
guitar
keyboard

followed by the months of the year

I dropped the months in the series field and that was fine. I then took
drum, guitar and keyboard and it reads "sum of guitars" "sum of keyboards"
"sum of drums".

I don't want the "sum of" to appear ..I just want "guitars" "keyboards"
"drums".

Thank you.
 
The data field names can't be exactly the same as the field names in
source table. However, you can use the field name, and add a space
character at the end:

In the Pivot Table, select a cell that contains the data field name,
e.g. Sum of Guitars
Type a new name, e.g. Guitars, and type a space character at the end
Press the Enter key to complete the change
 
You can make the changes in the pivot table, or double-click the Sum of
Guitars button on the pivot chart, and type the new name in the
PivotTable Field dialog box.
 
Back
Top