I have a pivot table with fields comprising of sums and average. I want to create two separate charts (one for the sum, and other for the averages).

Every time I try selecting a pivot chart, it shows both the fields.

What would be the most perfect way to use these pivot charts separately in one pivot table sheet in excel?

1 Answer

Because both charts are linked to the same PivotTable, if you change the field setting this means you change the PivotTable setting.

If you want to work with 2 Pivot Chart with the same PivotTable, try to fill No fill color for each Chart Series:

  1. Copy the Pivot Chart and Paste it: enter image description here

  2. No fill Color for each Chart: enter image description here

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy