Can I create more than one chart from the same pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create several charts from the same data. Is there a way to create
more than one pivot chart from the same pivot report?
 
John -

You can create multiple pivot charts, but they all have to have the data pivoted the
same way. If you change this in one chart, it changes it in the underlying table,
and then all charts based on that pivot table are changed.

Why not duplicate the first pivot table, rearrange it, and make a second chart from
the second pivot table?

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