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...
Joe78man
Apr 03, 2019Copper Contributor
No, you cant have multiple different graphs from the same pivot. If you create more than one, changing one will change all others.
The alternative is to copy and paste values and create many graphs from the value table, or if you want it dynamic, create a parallel table that calls out the values from the pivot table, so every time the pivot changes your parallel table will also change.
You do can create multiple graphs from a table (not pivot) and display different values in every graph
The alternative is to copy and paste values and create many graphs from the value table, or if you want it dynamic, create a parallel table that calls out the values from the pivot table, so every time the pivot changes your parallel table will also change.
You do can create multiple graphs from a table (not pivot) and display different values in every graph