Stacked columns in bar chart

[serfr]

Is it possible to make stacked columns in a bar chart like follows?

• Black column (3rd from right) consists from the data in H2+I2 (=G2)
• Red column (2nd from right) consists from the data in H3+I3 (=G3)
• Grey column (1st from right) consists from the data in H4+I4 (=G4)

I have covered these columns with the rectangular forms, how they should look like. I know, it looks weird

 

[RoryA]

That is a column chart, not a bar chart (where the bars are horizontal). It sounds like what you want is a stacked clustered column chart. If you google that, both Andy Pope and Jon Peltier have examples of that on their sites, showing the necessary data arrangement.