Pivot table with Multiple charts - different data display

Question

Hello,

I have a pivot table but it I want to be able to have 5 charts linked to the same pivot table and each chart displays it's assigned data. For instance, Chart 1 displays SITE_A pie chart that displays the percentage ratio between NON-PRODUCTIVE TIME and PRODUCTIVE TIME; Chart 2 displays the same information of SITE_B, etc.

Pivot table below:

SITE         ACTIVITY                                  HOURS RATIO

SITE_A NON-PRODUCTIVE TIME  4,391 55%

SITE_A PRODUCTIVE TIME                  3,621 45%

SITE_B NON-PRODUCTIVE TIME  639         27%

SITE_B PRODUCTIVE TIME                 1,757 73%

SITE_C NON-PRODUCTIVE TIME        1,725 40%

SITE_C PRODUCTIVE TIME                 2,616 60%

SITE_D NON-PRODUCTIVE TIME 3,104 41%

SITE_D PRODUCTIVE TIME                 4,510 59%

SITE_E NON-PRODUCTIVE TIME 1,028 51%

SITE_E PRODUCTIVE TIME                 969         49%

Thank you all in advance,

Alex

Answer 1

Hi, Alexbonr. I am Mitch, an independent advisor. I will try to help. To create multiple charts using 1 pivot table, copy the pivot table. To do this, click anywhere inside the pivot table to activate the pivot table tab, click Analyze > click Select dropdown >> Entire Pivot Table then copy and paste. Repeat until you have 5 pivot tables with same data. You can then create a chart of each copy. Right click anywhere in each chart to activate Pivot Table tab then click pivot chart.

Let me know if this works.

Thank you.

Answer 2

MitchMD,

Thanks for your response. That is how I have it set up now.

I want a single pivot table to be a source to 5 charts that display different information referring to the same pivot table, not the copies.

Thanks,

AlexBonR

Answer 3

Click the Pivot table value and choose Pivot Table Options - And under Totals and Filters - Allow Multiple Filters Per Field.

Now Adjust the Pivot Table fields to get the desired results, and create the chart1.

After creating chart, copy and paste the whole Pivot Table (you have 2 pivot tables now), Delete the previous pivot table from which you created chart 1.

Now the second Pivot Table, you adjust the Fields to get desired results and create the chart2

Copy and paste the whole Pivot Table, and delete the previous pivot table.

and go on.

see the picture.

Thank you.

Answer 4

You have to create measures for each site and base your chart on each measure.

you can display all charts for each measure/site or do a slicer

Answer 5

Jeganarayanan, thanks for the response. But the way you suggested is freezing charts with a given data and recreate (or paste) the same pivot and set it with a next condition and freeze again. 

I see where you are going with it, but it still does not solve my dilemma here: one pivot table as a source to multiple charts that are individually interchangeable. 

Thanks,

Alex