Can I change data chart labels?

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

~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

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

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