• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot charts

Hi, can someone please explain to me in layman's terms how I can create multiple pivot charts from the same pivot table, without modifying each chart with the current pivot? Do I have to create 15 different pivot tables to make 15 different charts, or can I create 15 different charts from the same pivot table without altering the data. Also, if this is feasible, can I freeze the data so it doesn't change when I change the pivot, and refresh it when I made any modification to my raw data?
 
Hi matthew_virgilio,


Welcome to the forums, following might help:


http://chandoo.org/forums/topic/best-way-to-create-multiple-charts-from-one-data-set

&

http://answers.microsoft.com/en-us/office/forum/officeversion_other-excel/is-there-a-way-to-create-multiple-graphs-from-one/d4a1d3c4-1a53-4f84-a4f2-31f8763e0a6f


Regards,
 
Back
Top