Changing a bar to a line in a combo chart

[imported_unknown]

I have a combination chart that I am ploting six columns of data. Excel automatically plots 3 on one axis (bars) and 3 columns on the secondary (lines). However, I want to change one of the bars to the secondary axis and also have it change to a line rather than a bar....how do I do it???

 

[Mark W.]

1. Select the series
2. Press Control+1
3. Choose "Secondary axis" on the Axis tab and press [ OK ].
4. Choose the Chart | Chart type... menu command and pick the Line Chart type.