Objective 2. Use a Chart to Make Comparisons

Table of contents:

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.


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



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.


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.


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.



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.


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



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.



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.


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.


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.


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.


You have completed Project 3A

Project 3B Lab Supervisors

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents

Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net