Make Column chart with four series
Right click on one data series in the chart
Use Chart Type form the shortcut menu
Select "Line"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Eileen" wrote in message
...
Does anyone know how to change a line to a bar in a chart? I'm plotting a
chart with four sources; I would like three to be bars (primary axis) and
the
forth to be a line (which is on the secondary axis). Does anyone know how
I
can change the lines to bars in the chart?