Task 8 Editing The Plotted Data
Objective To alter the data that you actually want plotted on the graph. Instructions You will use the
Comment It is sometimes the case that you either want to add an extra series to what you are plotting, or else you want to use the format for the current chart to plot a new set of data with. To do this you change the Data Series you plot.
Activity 8.1 From the Insert menu select the New Data command. The following dialogue box will appear.
Activity 8.2 Click on the <TUT28> tab at the bottom of the window to take you back to the TUT28 worksheet. Now using the mouse select the data in the following range (You may have to move the New Data dialogue box out of the way to see the range you want to select): E6:G10. When you have done that click on <OK>.
Activity 8.3 You will have noticed that the Y-axis is now unhelpful as it still has the settings we gave it in the previous exercise. Double click on the Y-axis and reset all the Scale settings to their defaults.
The graph as it stands actually isn't terribly informative. One alternative is to change it's subtype to a stacked column graph. That way you would still get information about the separate quarters, but the columns would relate better to the lines.
Activity 8.4 Using the Format Chart Type command, click on the Options button and select the Subtype tab. Choose the second column subtype - the stacked one - and click <OK>. The whole graph is altered to become a stacked column chart.
Activity 8.5 Ever since you started working on the chart you may have noticed a small toolbar floating in the top right hand corner of your screen. This is the Chart Toolbar and it can be used to shortcut menu commands..
Select the Actual Sales series by clicking on it once with the mouse. A box should appear in some or all of the columns on the chart. Now go to the drop down arrow in the Chart Toolbar. A palette of possible chart types appears. Select the 2-D line graph (4th down in the left hand column).
The graph changes so that the Actual Sales form a line graph over the top of the column graph. Now select the Target Sales series and do the same for that.
OSU | CoF | Community | Search | Forestry Computing Helpdesk
Disclaimer
Last Updated Monday, 25-Aug-1997 13:03:56 PDT