Can I change data chart labels?

[~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.

 

[Debra Dalgleish]

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

 

[~D~]

...but its a chart. I cannot change the data label. Do I have to modify the
pivot table?

 

[Debra Dalgleish]

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.