Several Pivot Charts One Sheet of Data
 

Is there an easy way to create several pivot charts off of one database in
the same document? Everytime I change one chart, the others change too.

Several Pivot Charts One Sheet of Data
 

The pivot chart and pivot table are linked, so changing one changes the
other.

Copy your pivot table, and make a new chart based on the copy.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"michelerocks" wrote in message
...
Is there an easy way to create several pivot charts off of one database in
the same document? Everytime I change one chart, the others change too.