Stacked chart with line

[Guest]

I would like to combine a stacked column on one axis with a line or data
points on the other axis (or two stacked charts on two axes). I know how to
create a chart on two axes, and I have managed to build my own model with one
stacked chart and another normal bar-chart. Does anyone know how to make the
normal bar-chart into a line or stacked bar?

 

[Guest]

Janneke, I just posted that question last week and got the answer from
another person. It's possible and it's easy.

Simply select the line or column that you want to change, right click it,
then select chart type. You can then select what you want, line or column or
whatever. You did what I did. You didn't realize that you can customise
each data series. You assumed that the combinations were limited by the
examples given in Excel. You can make each set of data whatever you want.

Hope that helps.
Diana