Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

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.

webmaster@allaboutoffice.co.uk