Home

How to build a stacked and clustered column graph in excel (with up to 4 sections per column)?

%3CLINGO-SUB%20id%3D%22lingo-sub-1054643%22%20slang%3D%22en-US%22%3EHow%20to%20build%20a%20stacked%20and%20clustered%20column%20graph%20in%20excel%20(with%20up%20to%204%20sections%20per%20column)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054643%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20build%20a%20stacked%20and%20clustered%20graph%20in%20excel.%20I%20have%20found%20this%20website%20which%20details%20how%20to%20do%20it%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.xelplus.com%2Fexcel-clustered-column-and-stacked-chart%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.xelplus.com%2Fexcel-clustered-column-and-stacked-chart%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20down%20side%20is%2C%20this%20only%20seems%20to%20work%20if%20you%20have%20up%20to%202%20sections%20per%20column.%20The%20data%20I%20am%20trying%20to%20display%20is%20from%20a%20survey%20looking%20at%20responses%20from%20pharmacists%20and%20from%20technicians.%20The%20possible%20answers%20are%3A%20very%20satisified%2C%20satisified%2C%20neutral%20and%20dissatisfied.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVisually%20the%20aim%20is%20to%20have%204%20questions%20each%20with%202%20clustered%20column%20graphs.%20Each%20column%20may%20be%20split%20into%20as%20many%20as%204%20sections.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20help%20out%20with%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1054643%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054653%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20build%20a%20stacked%20and%20clustered%20column%20graph%20in%20excel%20(with%20up%20to%204%20sections%20per%20column)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054653%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481720%22%20target%3D%22_blank%22%3E%40Brett1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20upload%20a%20sample%20of%20your%20data%20so%20that%20we%20can%20have%20a%20look%20at%20what%20you%20try%20to%20put%20in%20the%20graph.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055019%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20build%20a%20stacked%20and%20clustered%20column%20graph%20in%20excel%20(with%20up%20to%204%20sections%20per%20column)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055019%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20see%20attached%20the%20data%20and%20a%20simple%20sketch%20of%20what%20I%20am%20hoping%20to%20achieve.%20Thank%20you%20for%20your%20help!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055196%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20build%20a%20stacked%20and%20clustered%20column%20graph%20in%20excel%20(with%20up%20to%204%20sections%20per%20column)%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481720%22%20target%3D%22_blank%22%3E%40Brett1010%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHad%20a%20go%20at%20it%20and%20after%20reorganising%20your%20table%20a%20bit%2C%20came%20up%20with%20a%20%22100%25%20Stacked%20Column%22.%20%26nbsp%3BAdded%20a%20chart%20to%20the%20sheet%20%26nbsp%3Bthat%26nbsp%3Bresembles%20your%20sketch.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Brett1010
New Contributor

Hello!

I am trying to build a stacked and clustered graph in excel. I have found this website which details how to do it: https://www.xelplus.com/excel-clustered-column-and-stacked-chart/

 

The down side is, this only seems to work if you have up to 2 sections per column. The data I am trying to display is from a survey looking at responses from pharmacists and from technicians. The possible answers are: very satisified, satisified, neutral and dissatisfied.

 

Visually the aim is to have 4 questions each with 2 clustered column graphs. Each column may be split into as many as 4 sections.

Can anyone help out with this?

Thanks!

3 Replies

@Brett1010 

Please upload a sample of your data so that we can have a look at what you try to put in the graph.

Please see attached the data and a simple sketch of what I am hoping to achieve. Thank you for your help! @Riny_van_Eekelen 

@Brett1010 

Had a go at it and after reorganising your table a bit, came up with a "100% Stacked Column".  Added a chart to the sheet  that resembles your sketch.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies