Combination Chart

[David Barham]

I would like to know the procedure for creating a
combination chart with more than three data series and
only one data series represented by a line. In this
particular case my end result should be five data series
represented by bars and one data series represented by a
line.

Theres's gotta be a way!

Thakns.

- dave

 

[Debra Dalgleish]

Make a column chart with all the data.
Right-click on the series that you want as a line.
Choose Chart Type
Select Line category, and one of the subtypes
Click OK

Jon Peltier has information on creating your own combination charts:

http://www.peltiertech.com/Excel/Charts/ComboChart1.html