Home

Freeze Pivot Chart

ianpercy
Occasional Visitor

Hi,

 

I am wondering if it is possible to create multiple pivot charts from a single pivot table without them all auto updating when I manipulate the data in the underlying pivot table? For example, I create one chart, then I want to manipulate the table to create a second chart but without changing the first. 

 

Or is this just not possible and I have to create multiple pivot tables from the underlying data set as I have been doing?

Thanks.