This is a discussion on Stacked Chart, But not that simple! within the Excel Questions forums, part of the Question Forums category; Hi Everyone, I would like to make a stacked bar chart, but I need there to be 2 sets of ...
I would like to make a stacked bar chart, but I need there to be 2 sets of bars for each date. It will be a monthly chart and each month there will be 2 bars, one stacked chart for team 1 and one stacked chart for team 2 (the stack will show different score ranges). This is simple by just adding in the data 2 sets for each date, but what I find to be tricky is how to get the bars right next to eachther for each date, but separate between dates. So it would be like 2 bars together, then space, then 2 bars together, then space, etc
Any one with experience in this?
Welcome to the forum.
See for example, Jon Peltier's article here: Clustered and Stacked Column and Bar Charts - Peltier Tech Blog
or Andy Pope's here: Stacked cluster