Line-Column Chart Question

[Michelle]

In Chart Wizard, I selected the Custom Types, Line -
Column chart option (only 1 axis) in Excel to plot 6 data
series. I wanted 5 to be columnar and only 1 to be a
line. The wizard made three of each and I can't figure
out how to convert two of the data series back to
columns. Any suggestions?

Thank you -

 

[Debra Dalgleish]

1. Create a column chart from all the data
2. Select the series that you want to change to a line
3. Choose Chart>Chart Type
4. Choose a line chart type, click OK

Jon Peltier has information on creating your own combination charts:

http://www.geocities.com/jonpeltier/Excel/Charts/ComboChart1.html