testing for 90percentexcel.xlsx

Good morning I am hoping somebody maybe able to help me with the attached, I am trying to show current work and up and coming work compared to available man hours.

this would mean the green bar up against a stacked red and brown bar.

I have searched the internet for answers however the only thing I have found is to change the bar chart to a stacked bar chart with all three values together.

Please could somebody show me the errors of my ways

Regards

Steve