How do you do that in 2003?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/3/2010 12:55 AM, x Saed wrote:
i've been tinkering with 2007 to unlink a pivot chart from a pivot table. I know how to do that in 2003, but i suppose i didn't manage to find equivalent procedure in excel 2007...

the workaround, using paste as picture is not good enough, because the it cannot be edited anymore

Pls help



chscot wrote:

There's not a way to do this from what I know.
14-Feb-08

There's not a way to do this from what I know. You would need to create a
separate pivot table and pivot chart for each filter/view.

If you don't need to keep your pivot chart updating with the pivot table and
just want a few "snapshots", you could filter the pivot table the way you
want, then copy and paste the chart to a new workbook to "unlink" the chart
from the pivot table.