ExcelBanter - MS Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - MS Excel 2003 (https://www.excelbanter.com/charts-charting-excel/181941-ms-excel-2003-a.html)

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?

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?