Combination line and stacked bar charts

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

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


"Ian" wrote in message
...
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

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ian wrote:
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