I am attempting to change my legend in a Pivot Chart report. However, when I
go the Pivot Table to change the cell a dialog box appears telling me that
this cell can't be changed. How do I change the text of this legend? Thanks
for your help.

What part of the pivot table are you trying to change? You can't change
the "Total" heading, or cells in the data area.

SJT wrote:
I am attempting to change my legend in a Pivot Chart report. However, when I
go the Pivot Table to change the cell a dialog box appears telling me that
this cell can't be changed. How do I change the text of this legend? Thanks
for your help.




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

Thanks for responding. I tried to change the column heading and it would not
permit that modification. How else can I change the legend in the pivot
chart? Is there another way? Thanks again.

"Debra Dalgleish" wrote:

What part of the pivot table are you trying to change? You can't change
the "Total" heading, or cells in the data area.

SJT wrote:
I am attempting to change my legend in a Pivot Chart report. However, when I
go the Pivot Table to change the cell a dialog box appears telling me that
this cell can't be changed. How do I change the text of this legend? Thanks
for your help.




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