Serious Issues with Graphs stacked and line

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.