jimbogarner
Board Regular
- Joined
- Apr 22, 2010
- Messages
- 102
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);
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 |