Can I change data chart labels?

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.
 
D

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

~D~

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

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.
 
Top