how to persist pivot chart data

[chicagoman]

I have two worksheets: one sheet to do scratch work, and one to contain the
final product. I do the following:

1. Make a filter selection on the scratch sheet and copy the resulting pivot
table and pivot chart to the final sheet.
2. Make another filter selection on the scratch seet and copy the resulting
pivot table and pivot chart to the final sheet. ( I actually do many
iterations of this.)

Unfortunately, when I make another filter selection in the pivot table on
the scratch sheet and copy the table to the final sheet, the first pivot
chart on the final sheet reflects the results of the new filter selection
instead of preserving its original values. How can I prevent this?

 

[Shane Devenshire]

Hi,

As you are doing it, you can't. All pivot charts that come from the same
pivot table cache, display the data the same way. You have thress possible
solutions that I know of, none really very satisfactory:

1. Make multiple pivot tables from the same data sourse but each with its
own cache, then chart these.
2. Copy the chart as a picture
3. Copy the pivot table and paste it as values somewhere else (Edit, Paste
Special, Values). And then plot that area.