Pivot Chart - How to create multiple charts from same data

Question

Hi,

Is there any easy way to create multiple chart from same pivot table data?

If I copy the chart that I have, then the result is that two charts are showing exactly the same information. Instead I want that one chart is showing one set of information and other chart showing another piece of based on my filters. So if I make a copy of the first pivot chart, is there any way to break the link between the original and copy chart?

Answer 1

Load the data into a Data Model.

In Power Pivot you can create multiple charts even without a visible Pivot table in the sheet!

If you need a sample file share some data and show the expected result.

Andreas.

Answer 2

Hello Tommy

I’m Adeyemi and I’d be happy to help you with your question. In this forum, we are Microsoft consumers just like yourself.

Yes, there are a few ways to create multiple charts from the same pivot table data.

One way is to copy the pivot table and paste it multiple times, then create a chart for each copy.

Another way is to select any cell within the pivot table and insert a column, line, pie, or radar chart from the Insert tab. Then, pivot the chart by changing or moving fields using the PivotChart Field List. Repeat the chart creation process and choose a different type of chart for each pivot table field.

If you make a copy of the first pivot chart, it will still be linked to the original pivot table data. To break the link between the original and copied chart, you can create a new pivot table and chart based on the same data source.

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below

Regards, Adeyemi