Forum Discussion
2 bars next to each other in a stacked bar chart
I don't think Excel has a chart type that provides both a stacked bar and side by side series.
For that, you could create a chart of the 'clean' values with transparent chart and plot areas and superpose it on a second chart that shows the 100% stacked totals.
Thank you for the help!
I am trying but have another question.
So you make the underlying one with thicker bars and then you put the transparant one on top, but how do you get the transparant one then more to the left or right? Thank you in advance!
Many effects are possible. What I used were two ordinary series charts. These are then overlaid to give the illusion of a stacked chart with multiple series (or to give a 'thermometer' chart if you prefer).
to give
Tip: Using Home / Find & Select / Selection pane with Show / Hide can make it easier to work with the constituent charts.
