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