Google Combo Charts

Hi,

I am trying to replicate an excel graph on Google sheets, the below is what i'm trying to achieve (IE what I currently have in excel);


This is using a custom graph in excel, I've tried using a combo graph in Google sheets with the bars being stacked bar charts and the lines for 'target' being scattered with straight lines. I tried replicating this using a combo chart in excel but I can't seem to get the targets to be lines across the chart...

The chart is reading from the following in cells A1:B5 (Ignore the dates not typing to the above excel snip, the graph above is from an old excel file);