Google Combo Charts

[jimbogarner]

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);

Week 13 to date actual	13,370,453
Week 13 to date target	14,294,457
Q1 target	14,294,457
Payouts start	12,150,288
Target hit	14,294,457

 

[jimbogarner]

https://docs.google.com/spreadsheets/d/1cVGDbQMPKHNXWfGjm6S2Qx4WY86jXeW9efCbst3NvBw/edit?usp=sharing

Link to example spreadsheet