2 bars next to each other in a stacked bar chart

[Ellen8008]

Hi,  

I would love to get to bars next to each with one including clean inventory vs dirty inventory in units and one clean inventory vs dirty inventory in costs. So that for every number on x-axis there are 2 bars next to each other. This is what I got so far: The two bars are behind each other and I am working with two y-axis even though they are the same? Someone any tips how I get them next to each other? Thank you! 

 

[#2]

@Ellen8008 

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.

[#3]

@Peter Bartholomew 

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!

[#4]

@Ellen8008 

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.