Create multiple Graphs on one sheet form one pivot table on another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-69116%22%20slang%3D%22en-US%22%3ECreate%20multiple%20Graphs%20on%20one%20sheet%20form%20one%20pivot%20table%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69116%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%2025%20different%20graphs%20(All%20on%20one%20sheet)%20from%20one%20Pivot%20table's%20data%20(different%20sheet)%2C%20without%20the%20pivot%20table%20creating%20multiple%20different%20pivot%20tables.%3C%2FP%3E%3CP%3EAlso%2C%20the%20graphs%20need%20to%20update%20every%20month%20when%20the%20pivot%20table%20is%20updated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20all%20data%20are%20copied%20and%20pasted%20into%20different%20tables%20and%20then%20graphs%20created%20from%20each%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3ESimone%20Fick%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-69116%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394101%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20multiple%20Graphs%20on%20one%20sheet%20form%20one%20pivot%20table%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394101%22%20slang%3D%22en-US%22%3ENo%2C%20you%20cant%20have%20multiple%20different%20graphs%20from%20the%20same%20pivot.%20If%20you%20create%20more%20than%20one%2C%20changing%20one%20will%20change%20all%20others.%3CBR%20%2F%3EThe%20alternative%20is%20to%20copy%20and%20paste%20values%20and%20create%20many%20graphs%20from%20the%20value%20table%2C%20or%20if%20you%20want%20it%20dynamic%2C%20create%20a%20parallel%20table%20that%20calls%20out%20the%20values%20from%20the%20pivot%20table%2C%20so%20every%20time%20the%20pivot%20changes%20your%20parallel%20table%20will%20also%20change.%3CBR%20%2F%3EYou%20do%20can%20create%20multiple%20graphs%20from%20a%20table%20(not%20pivot)%20and%20display%20different%20values%20in%20every%20graph%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394097%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20multiple%20Graphs%20on%20one%20sheet%20form%20one%20pivot%20table%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394097%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20think%20It%20is%20pretty%20clear%20%22%20Create%20multiple%20Graphs%22%20multiple%20means%20more%20than%20one.%20You%20just%20explained%20how%20to%20create%20a%20chart%20which%20is%20evidently%20known%20already.%20If%20he%20needs%20to%20create%20multiple%20he%20must%20know%20how%20to%20create%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20my%20level%20of%20sarcasm%2C%20included%20in%20this%20apology%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-69174%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20multiple%20Graphs%20on%20one%20sheet%20form%20one%20pivot%20table%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-69174%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Simone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20one%20Pivot%20Table%20you%20may%20bild%20as%20many%20different%20charts%20as%20you%20need%2C%20all%20of%20them%20will%20be%20updated%20together%20with%20Pivot%20Table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Ribbon%20-%26gt%3BPivotTable%20Tools-%26gt%3BAnalyze%20click%20on%20PivotChart%20icon%20for%20creating%20every%20new%20chart.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20was%20your%20question%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995750%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20multiple%20Graphs%20on%20one%20sheet%20form%20one%20pivot%20table%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995750%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F42015%22%20target%3D%22_blank%22%3E%40Simone%20Fick%3C%2FA%3E%26nbsp%3B%2C%20an%20alternative%20is%20to%20Insert%20a%20Chart%20while%20referencing%20empty%20cells%2C%20then%20editing%20the%20data%20references%20for%20the%20Chart%20thereby%20referencing%20the%20specific%20Legend%20Entries%20(data%20series)%20information%20in%20your%20pivot%20table.%20(Don't%20reference%20information%20contained%20in%20the%20Grand%20Total%20field%20of%20the%20Pivot%2C%20as%20this%20converts%20the%20Chart%20-%26gt%3B%20Pivot%20Chart!)%20Once%20you%20individually%20add%20Legend%20Fields%2C%20you%20can%20duplicate%20this%20chart%20for%20X%20amount%20of%20times.%20Now%20you%20can%20select%20which%20Legend%20Entry%20(Series)%20you%20want%20by%20toggling%20the%20Filter%20to%20the%20right%20of%20the%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

 

Thank you

Kind regards

Simone Fick

4 Replies

Hi Simone,

 

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?

@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

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

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.