Combination line and stacked bar charts

[Ian]

I want to overlay a line series on top of a STACKED bar
chart. I can only seem to get the bar charts side by
side - not stacked. Alternatively, can you just convert a
bar series into a line series.

Thanks in advance - Ian K

 

[Bernard V Liengme]

Hi Ian,
Make abackup of your file and try this
Right click on one data sereis (column) in the cahrt, selct Chart type from
the poup menu; selct Line from the options.
This will leave one data sereis as a column but the other as a line.
Bernard
(e-mail address removed)

 

[Jon Peltier]

Ian -

Make your chart using all the data, as a stacked bar type chart. Select
the single series you want to change, then choose Chart Type from the
Chart menu, and select Line. The rest of the series remain as stacked bar.

- Jon