Forum Discussion
Multiple pivot charts from single pivot table
Hi Team, I’m trying to create 2 different charts with different fields from a single pivot table where I have all the required fields for the 2 charts. I tried applying filter and removing ir...
As you have found, there is a one-to-one link between a pivot table and any associated pivot chart.
So you'll have to create two independent pivot tables from the same source data, and then create a pivot chart from each of them.
See for example How do I “separate” Pivot Tables or Group Two Excel Pivot Tables Independently