Serious Issues with Graphs stacked and line

[kryt0n]

Hi all,

I am desperate now and need some serious help with this.

Please see attached .xls for the best explanation.

I have data, I need the data to end up looking like the graph I have 'drawn' on the sheet. I know how to make a stacked graph, I know how to make a line graph. How do I combine the two? Do I need to use something other than the standard graph options?

I have never made a histograph before and not sure I have the time today to learn and produce what I need to. Please someone help me with this. I want to learn and understand but don't know how to display the data correctly.

[kryt0n]

Come on guys please help me? It might even be a case of superimposing a graph on another. I just don't know. Please help.

[sweep]

Create a stacked column chart with ALL the data. Select the data you want as a line, right click and select "Change series chart type" then select line.

[kryt0n]

Thank you!