If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I create more than one chart from the same pivot table?
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? |
#2
|
|||
|
|||
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/ _______ Johana wrote: 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table option, display as data list, repeating items down | carl.fields | Worksheet Functions | 4 | September 17th, 2004 07:57 PM |
Pivot Chart / Table | Bilbo Baggins | Charts and Charting | 1 | March 16th, 2004 11:17 AM |
How to extract data from multiple Access databases to create a Pivot table | Android | Worksheet Functions | 4 | February 6th, 2004 03:22 PM |
Writing a Macro to create a pivot table | Dave Peterson | Worksheet Functions | 4 | January 5th, 2004 01:19 AM |
Pivot table chart - Data labels | Rick | Charts and Charting | 1 | October 14th, 2003 05:06 PM |