Changing Chart Type
If you have created a chart with all the series looking
the same you may wish to change some series to line and some to columns.
We have a chart of rainfall and umbrella
sales with all the data shown as columns.
To change an umbrella sales series to a column, click on
the series or select it using the Chart Object Selector on the
Chart Toolbar and then click on the Chart drop-down menu and select Chart
Type. Select the column chart
type and click OK, this series will now be converted to a column.
You can tell which lines relate to the umbrellas by hovering your mouse
over the line, a small box will appear telling you the series name.
By repeating this for all the umbrella series we can
change all the umbrella data to columns with the rainfall remaining as
lines as shown below:
Click here to
return to the Excel index.