Combined charts - x-y scatter (or line) and columns

[Kurt Bonner]

"How do I change the format of a data series in a chart from a line to a column?"

 

[dvt]

"How do I change the format of a data series in a chart from a line toa
column?"

Select the data series by clicking on it. On the menu, click Chart |
Chart type | select a column chart. If you do this as instructed (i.e.
with the data series selected), only the selected data series will
change. The other data series will remain as before.

 

[Jon Peltier]

Select the data series by clicking on it. On the menu, click Chart |
Chart type | select a column chart. If you do this as instructed (i.e.
with the data series selected), only the selected data series will
change. The other data series will remain as before.

Even quicker: right click on the series, choose Chart Type from the pop
up menu, and select the intended chart type.

And if you want to repeat this with another series, select the second
series right after changing the first, and press the F4 key.

- Jon