PDA

View Full Version : Pivot Chart and Table Problem



mzsuga
08-11-2009, 08:07 AM
I have a pivot table and a pivot chart on one sheet. Then i copy and paste that sheet in the same workbook. And I want to change the pivot chart on the copied sheet but then the chart refers to the original sheet. Is there any way to change that?

Any help please?

Bob Phillips
08-11-2009, 09:05 AM
A pivotchart is based upon a pivottable, so you would have to change the source of the pivottable, which may not be what you want.

Hoopsah
08-12-2009, 07:15 AM
If you are only wanting to edit the data produce by the pivot table (???) then copy and paste special - Values