Excel bar graph multiple data sets

Hello,

I've tried to make a excel file showing what I want to illustrate.

I have three data sets: Total Sales (which includes chair sales), chair sales and competitor sales.

I want to make a bar graph with two bars per time interval (per quarter). The first bar should only be Competitor sales by itself. The second bar should be Total sales, but which also includes chair sales, in order to show how big portion of total sales comes from chairs.

I've only managed to create the graph either with all three data sets in three different bars or them all merged in one bar. Can someone help me with this?


/Peter