Plotting 2 different graphs on 1 set of axes

Hi,

I am trying to essentially plot 2 different graphs on the same axis. The first graph is a basic clustered bar graph, and the second is a stacked bar chart. I have been able to create them seperately (see attachment) but I can't work out how to put them on the same axis?

As an extra note - The attachment is just an extract from the spreadsheet I'm working on (just to keep things simple). In the real spreadsheet, the table that the graphs run off is automatically populated by macros because the data is changing on a daily basis. I did this so I didn't have to keep manually updating the table and graphs everyday. Don't know if this will make a difference but thought it was worth mentioning.

Does anyone know how to do this?

Thanks in advance,

Chris

Thanks very much Andy - this works well!

Chris