Field List for PivotChart and PivotTable

kyrendaniel

New Member
Joined
Sep 19, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Is it possible to create a PivotChart and PivotTable from the same information but display different information in each? I created a pie chart based on a PivotTable for an assignment, and when I moved the fields between areas like the legend and axis in the field list, it modified both the chart and the PivotTable. Is there a way to display different information in each? Could I also have multiple PivotCharts display separate parts of the table and be modified separately from the PivotTable and each other?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Welcome to the board!

The pivot charts are based on pivot tables so no, you can't have a chart and a pivot table showing different information.

However, you can create several pivot tables ( and charts) based on the same data and have them display different views of the same data. You can even connect your slicers to work with all your pivot tables so if you have your pivot tables in different sheets, you can copy the graphs based on those tables visible on the same worksheet as the pivot table you want to show in your report and have the same slicers control all your pivot tables (even if they're sitting on hidden sheets).

The only catch is all the pivot tables have to be based on the same pivot data (pivot cache).
 
Upvote 0

Forum statistics

Threads
1,223,892
Messages
6,175,236
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top