How to I set up this chart?

It looks like a pretty standard stacked column + line combination chart. I see one line chart data series and six stacked column chart data series. Not knowing what data you have or how it's arranged in the spreadsheet, I would expect to work towards arranging the data in the sheet something like this (note that I'm assuming the y axis starts at 0 and values increase going up. If that assumption is incorrect, this will look a little different):

Please Login or Register  to view this content.

Select this table and insert a stacked column chart. Change the chart type for the line chart series to line chart to create the combo chart. Format chart elements as desired, formatting the "blank column" series to be invisible (no border, no fill).

That's what I would expect to do. Does that help you get started?

I don't understand what the data means, so I cannot readily see how to manipulate this source data to get it into the table that will be necessary for the stacked column + line chart. I find that many chart questions really end up being more about the spreadsheet than the chart. If you help us understand what data you are starting with, how you intend to calculate the data that the chart will show, we should be able to help you arrange those calculations in the spreadsheet. If we do that part well, I expect the chart will be easy to create from there.