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/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
multiple charts from a single pivot table 2
Charts 1
How do i export a pivot chart as a static chart object? 2
Pivot Chart Created from Pivot Table is Blank 1
Pivot Chart won't refresh! 3
Set uniform scaling for same type of Pivot charts with varying dat 1
refreshing charts 3

Back
Top