Combine stacked column and line chart w/series lines

My application requires a stacked colunm chart with series lines combined
with a minimum of three (3) data series represented as lines. Using the
combined column-line chart I loose both the column "stack" and series lines
between column elements. Any help adding Lines for three data series to and
existing stacked column chart will be most appreciated.

The built-in custom types have limited usefulness. Here's how to make your
own combination charts.

Plot all data as stacked columns. Double click a column and on the Options
tab, select Series Lines. Select a series you want changed to a line, choose
Chart Type from the Chart menu, and choose the line style you want. Repeat
for another series, or press the F4 key.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"ancillaries" <[email protected]> wrote in message
news:[email protected]...
> My application requires a stacked colunm chart with series lines combined
> with a minimum of three (3) data series represented as lines. Using the
> combined column-line chart I loose both the column "stack" and series
> lines
> between column elements. Any help adding Lines for three data series to
> and
> existing stacked column chart will be most appreciated.