Forum Discussion
Brett1010
Dec 08, 2019Copper Contributor
How to build a stacked and clustered column graph in excel (with up to 4 sections per column)?
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 ...
Riny_van_Eekelen
Dec 08, 2019Platinum Contributor
Please upload a sample of your data so that we can have a look at what you try to put in the graph.
- Brett1010Dec 08, 2019Copper Contributor
Please see attached the data and a simple sketch of what I am hoping to achieve. Thank you for your help! Riny_van_Eekelen
- Riny_van_EekelenDec 09, 2019Platinum Contributor
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.