Line-Column Chart Question

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 -

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

Jon Peltier has information on creating your own combination charts:

http://www.geocities.com/jonpeltier/...mboChart1.html

Michelle wrote:
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?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html