Forum Discussion
Simone Fick
May 11, 2017Copper Contributor
Create multiple Graphs on one sheet form one pivot table on another sheet
I need to create 25 different graphs (All on one sheet) from one Pivot table's data (different sheet), without the pivot table creating multiple different pivot tables. Also, the graphs need to upda...
Name1323
Nov 08, 2019Copper Contributor
HelloSimone Fick , an alternative is to Insert a Chart while referencing empty cells, then editing the data references for the Chart thereby referencing the specific Legend Entries (data series) information in your pivot table. (Don't reference information contained in the Grand Total field of the Pivot, as this converts the Chart -> Pivot Chart!) Once you individually add Legend Fields, you can duplicate this chart for X amount of times. Now you can select which Legend Entry (Series) you want by toggling the Filter to the right of the chart.