Stack-Line Chart

Hi All !

I want to make a chart which should show data in Stack+lines for following data. Two series should be stacks & other two should be in lines. Chart should be on two axes. Data is as under.

Jan-09 Feb-09 Mar-09
D-1 1 2 4 It should be Stack bar.
D-2 3 4 6 It should be Stack bar.
D-3 5 6 10 It should be line.
D-4 7 8 12 It should be line.

It is easy for the chart type Line-Column on 2 Axes but it does not allow two make it as stack+ line chart.

Is it possible two make such chart or not?

Cheers

Ignore the built-in combination charts.

Create a stacked column chart on all four data series.
Then select one of the series to move to the secondary axis.
Then move the other series.

Now change those 2 series to be stacked lines.