Combine stacked column and line chart w/series lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
_______
 
Back
Top