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