stacked and clustered columns graph
Pretty often I need to create sales graph. My data are revenue type, outlet and date. I wish I could have a stacked and clustered columns graph. That way, I could compare per month the revenue per outlet and the split par revenue type
Thanks for the feedback. This is an interesting chart type. We will consider it during our planning for the next round of new chart types. Please continue to vote on this feature idea.
Nick Gobin commented
There are so many hack workarounds out there to achieve this. None of them are good. Many people clearly need this feature (including myself). Would be great to have it implemented.
Really need this - we've built a team capacity tracker pivot which has months (x axis) roles (clustered columns) and categories (stacked in each column).
Confused why this isn't an option given all the information is there!
Kavin SAG commented
I need in the clustered chart, 3 columns, where as the 3rd column alone needs to be a stacked column to clarify the components of the 2nd column.
Yes, please. Excel's inability to do this is a regular frustration. Just today, I had to create one from a workaround, and a colleague also asked me for help in creating one for something unrelated.
Ideally, (and not necessarily specific to a stacked clustered bar chart) the user would be able to group data series and specify group spacing and data series offsets left or right from center of tick mark, which would help when plotting against two axes.
Gerdami Des Betes commented
See also Jon Peltier's blog on Clustered and Stacked Column and Bar Charts at
The entire world wants this feature. Excel can do almost everything - but not this!
David Robinson commented
This would be very useful. A quick example: ER gets a certain volume of patients turn up. Arrivals is column 1. Patients can either be fixed up and discharged, or admitted into hospital as an inpatient, or sadly die. These three outcomes should be stacked in column 2 so the overall height can be compared with arrivals to see if ER is getting busier or less busy.
Best place to put this fiunctionality would probably be a new chart type with "Group" as an option in "Select data": the group could be a special type of series which when you edit it you can then add more series within the group.
Kenneth Barber commented
I remember asking Bill Jelen about that years ago. The trick was to use a stacked graph where your source data had blank cells where the gaps should go. Of course, if the data comes from a table or PivotTable, you can't really do that... Then there are PivotCharts, which do not use gaps for separation of groups, but rather groupings labels on the x-axis.