Plotting a standard bar graph on the same axes as a stacked bar graph

Hi all,

I am hoping you can assist me with the following problem.

I am attempting to produce a graph that includes both a bar chart and a stacked bar chart on the same set of axes.
I have attached an example spreadsheet with a picture of what I am aiming for.

Any questions, please do not hesitate to ask.

Thanks

Took quite a bit of moving things around, but got there in the end.

Thanks for the assistance Andy.

Is this the only way of achieving this result? I ask for future reference, in case I require this sort of graph for larger databases.

Ok, thank you.