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.

~D~ wrote:
> ..but its a chart. I cannot change the data label. Do I have to modify the
> pivot table?
>
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
> news:41F4556F.2040803@contexturesXSPAM.com...
>
>>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~ wrote:
>>
>>>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
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>

>
>
>



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html