Combination line and stacked bar charts

I

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
 
B

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
[email protected]
 
J

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
 
Top