Home

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
Simone Fick
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

3 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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies