View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.