Stacked Bar Chart Comparison

[ryancgarrett]

Sorry, not sure how to word exactly what I'm looking for, and Google has not returned what I need.

I have a data set with results from 3 divisions (A,B,C). I'd like to create a bar chart the stacks quarterly results from A and B and displays them next to C.

i.e. in Quarter 1 A had $40 million revenue, B had $75 million and C had $100 million. A and B will be stacked (but different colors) totaling $115 million, displayed next to C at $100 million. Then have this go on for all 4 quarters I have data for.

Is there a way to do this?

 

[Misca]

The trick is to create a stacked column chart with series A & B on the same row and series C on another row. Add empty rows and play with the gap width to make your chart look better.