Task 5 Changing the Chart Type

Objective To change the type of chart plotted whilst using the existing set of data.

Instructions You will use the Chart Type.... command from the Format menu.

Comment Different graph types are useful for different sorts of data or for different emphasis on the data.

Activity 5.1 From the Format menu select Chart Type.... The following dialogue box appears showing the alternative 2-D graphs available. Select Area and click <Options...>.

When you click on Options, the following tabbed dialogue box appears:

Activity 5.2 Select the second subtype and click on <OK>. The graph alters to show an area graph. Note that the Y axis has altered its scale for the new graph. Type 2 Area graphs stack data so that the value for the top line of, say, Q2, is equal to the sum of all the values in Q2.

Before continuing, put the graph back to the 2-D column graph you originally had by going back to the Chart Type... dialogue box.

OSU | CoF | Community | Search | Forestry Computing Helpdesk