Objective 2. Use a Chart to Make Comparisons

The SUM, AVERAGE, MIN, and MAX statistics provide information about the similarities and differences between two groups of data. If the data follows patterns, those patterns are usually easier to see in a chart. In this example, a line chart is appropriate because time (months) represents a single set of values and a line chart is effective when displaying a pattern over time.

Activity 3.4. Using a Chart to Recognize a Pattern

In Activity 3.4, you will compare the rainfall in the two cities with a line chart and look for a difference in patterns.

1.

With your 3A_Geography_Lecture workbook displayed, select the range C4:E16, and then on the Standard toolbar, click the Chart Wizard button .

 
 

2.

In the displayed Chart Wizard dialog box, under Chart type, click Line. Under Chart sub-type, in the second row, be sure the first sub-type is selectedLine with markers displayed at each data value.

 

3.

In the displayed dialog box, click Next and compare your screen with Figure 3.11.

 

Figure 3.11.

A preview chart with two lines displays the months along the horizontal (X) axisalso known as the category axis.

 

   

4.

In the displayed dialog box, click Next. As the Chart title type Average Rainfall and as the Value (Y) axis title type Inches Wait a moment for the labels to display on the preview chart, and then compare your screen with Figure 3.12.

 

 

Figure 3.12.

 

5.

Click the Legend tab and move the legend to the Bottom of the chart. Click Next, and then click Finish to place the chart on the worksheet with the data. Click outside the chart to deselect.

 

6.

In the Name Box, type a1:g45 and then press . On the Standard toolbar, click the Zoom button arrow , and then click Selection.

 
   

7.

Drag the chart below the data and place the upper left corner in the middle of cell A24. Drag the lower right corner sizing handle to the middle of cell G41 and then click an empty cell to deselect the chart. Compare your screen with Figure 3.13, noting that the months on your chart may display vertically or horizontally, rather than on an angle.

 

 

Figure 3.13.

 

8.

Zoom back to 100%. Display the Page Setup dialog box. On the Margins tab, center the worksheet Horizontally. On the Header/Footer tab, create a Custom Footer and insert the file name in the Left section. Click OK to close the Footer and the Page Setup dialog boxes.

 

9.

Save your workbook. Check your Chapter Assignment Sheet or Course Syllabus, or consult your instructor, to determine if you are to submit your assignments on paper or electronically using your college's course information management system. To submit electronically, go to Step 11, and then follow the instructions provided by your instructor.

 

10.

To print the worksheet, click the Print Preview button . Confirm that the worksheet is centered horizontally and that the file name displays in the left section of the footer. On the Print Preview toolbar, click Print and then in the Print dialog box, click OK. If you have been instructed to print the formulas, refer to Chapter One on how to do so.

 

11.

If you printed your formulas, be sure to redisplay the worksheet by pressing . From the File menu, click Close. Do not save the changes that you made for printing formulas. Close the workbook and Excel.

 

End

You have completed Project 3A

Project 3B Lab Supervisors
Related

Категории