Struggling with a multi bar chart and wanting to add an s curve - here is the source data - not sure if this will work, but wanted to show the accumulated curve over top of the bar chart for ABC? It might be that I have my data structured incorrectly to get the result I want? The chart looked good with the data for A, B, C but I do not know how to now add the 3 remaining rows of data to create the s curve over top. Any help or advice would be much appreciated - thank in advance.
<colgroup><col><col span="6"><col span="2"></colgroup><tbody></tbody>
<colgroup><col><col span="6"><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col span="6"><col span="2"></colgroup><tbody></tbody>
QTR 1 | QTR 1 | QTR 2 | QTR 2 | QTR 3 | QTR 3 | QTR 4 | QTR 4 | |
Forecast | Actual | Forecast | Actual | Forecast | Actual | Forecast | Actual | |
A | 6 | 8 | 12 | 14 | 30 | 6 | 32 | 0 |
B | 3 | 3 | 2 | 2 | 5 | 1 | 15 | 0 |
C | 0 | 1 | 1 | 1 | 3 | 4 | 9 | 0 |
A Accumulated | 6 | 8 | 18 | 22 | 48 | 28 | 80 | 28 |
B Accumulated | 3 | 3 | 5 | 5 | 10 | 6 | 25 | 6 |
C Accumulated | 0 | 1 | 1 | 2 | 4 | 6 | 13 | 6 |
<colgroup><col><col span="6"><col span="2"></colgroup><tbody>
</tbody>