combining a stacked column and line chart together

[Abi Dodds]

I need to know how I combine a stacked column chart with a line chart (2 or
more lines are required on the chart) with two different y axis values.

 

[Jon Peltier]

Create a stacked column chart using all of the data. Select a column series
in the stack that you want to change to a line. Go to Chart menu > Chart
Type, and select a line type. Repeat as needed for other series. Double
click on any series you want to move to the secondary axis, and on the Axis
tab, select Secondary. Repeat as needed. You should try to keep all of the
stacked columns on the same axis, otherwise they will not stack correctly,
and stacking differently scaled columns makes no sense.

- Jon