Pivot Chart: freeze rather than refresh data--How to?

[TomYC]

There is much discussion on refreshing data in Pivot Tables & Pivot Charts, but what about "freezing" this data? I have a Pivot Table & Chart, but my goal is a set of several charts, each based upon a modification of an underlying pivot table. Of course, refreshing gives me only the latest.
In effect I want to copy and paste each of 4 different scenarios on to one final "dashboard" presentation sheet.
Can I do this without creating one separate pivot table and pivot chart for each scenario?

 

[SkipVought]

Hi,

Make separate PTs or loop thru each scenario, copy and Edit > Paste Specia - VALUES into your dashbaord.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[TomYC]

Thank you Skip.
That's basically what I'd been doing. Before that I'd pasted the chart in, then got surprised by the dynamic update!