Display multiple measures in a bar-line chart

[Jon3sy]

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.


[TABLE="width: 1792"]
<colgroup><col><col span="6"><col span="2"></colgroup><tbody></tbody>[/TABLE]

[TABLE="width: 1498"]
<colgroup><col><col span="6"><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]QTR 1 [/TD]
[TD]QTR 1 [/TD]
[TD]QTR 2[/TD]
[TD]QTR 2[/TD]
[TD]QTR 3[/TD]
[TD]QTR 3[/TD]
[TD]QTR 4[/TD]
[TD]QTR 4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Forecast[/TD]
[TD]Actual[/TD]
[TD]Forecast[/TD]
[TD]Actual[/TD]
[TD]Forecast[/TD]
[TD]Actual[/TD]
[TD]Forecast[/TD]
[TD]Actual[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]12[/TD]
[TD]14[/TD]
[TD]30[/TD]
[TD]6[/TD]
[TD]32[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]15[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]9[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]A Accumulated[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]18[/TD]
[TD]22[/TD]
[TD]48[/TD]
[TD]28[/TD]
[TD]80[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]B Accumulated[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD]6[/TD]
[TD]25[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]C Accumulated[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]13[/TD]
[TD]6
[/TD]
[/TR]
</tbody>[/TABLE]