May 11 2017
- last edited on
Jul 25 2018
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 update every month when the pivot table is updated.
How is this possible?
Currently all data are copied and pasted into different tables and then graphs created from each table.
May 11 2017 05:59 AM
On one Pivot Table you may bild as many different charts as you need, all of them will be updated together with Pivot Table.
In the Ribbon ->PivotTable Tools->Analyze click on PivotChart icon for creating every new chart.
That was your question?
Apr 03 2019 12:29 PM
@Sergei Baklan I think It is pretty clear " Create multiple Graphs" multiple means more than one. You just explained how to create a chart which is evidently known already. If he needs to create multiple he must know how to create one.
Sorry for my level of sarcasm, included in this apology
Apr 03 2019 12:34 PM
Nov 08 2019 10:53 AM
Hello@Simone 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.