INTRODUCTORY MICROSOFT EXCEL Lesson 8 Worksheet Charts Microsoft

INTRODUCTORY MICROSOFT EXCEL Lesson 8 – Worksheet Charts Microsoft Office 2003: Introductory 1 Pasewark & Pasewark

Objectives Excel – Lesson 8 l 2 l l l Identify the purpose of charting worksheet data. Identify the types of worksheet charts. Create a chart sheet and save a chart. Switch between charts and worksheets, zoom, and rename a chart. Microsoft Office 2003: Introductory Pasewark & Pasewark

Objectives (cont. ) Excel – Lesson 8 l 3 l l Preview and print a chart. Create an embedded chart. Edit a chart and change the type of chart. Microsoft Office 2003: Introductory Pasewark & Pasewark

Excel – Lesson 8 Terms Used in This Lesson 4 l l l Axis Chart sheet Chart Wizard Column chart Data labels Microsoft Office 2003: Introductory l l l Data series Embedded chart Image handles Line chart Pie chart Scatter chart Pasewark & Pasewark

Identify the Purpose of Charting Worksheet Data Excel – Lesson 8 l 5 l A chart is a graphical representation of data contained in a worksheet. Charts make the data in a worksheet easier to understand. Microsoft Office 2003: Introductory Pasewark & Pasewark

Identify the Types of Worksheet Charts Excel – Lesson 8 l 6 You can create several types of worksheet charts: – – l column charts line charts pie charts scatter charts Several types of charts can also be created three-dimensionally. Microsoft Office 2003: Introductory Pasewark & Pasewark

Create a Chart Sheet and Save a Chart Excel – Lesson 8 l 7 l A chart created from a worksheet is considered part of that worksheet. When you save the worksheet, you will also save the charts. Microsoft Office 2003: Introductory Pasewark & Pasewark

Switch Between Charts and Worksheets and Use Zoom Excel – Lesson 8 l To switch between a worksheet and a chart, click the tab of the worksheet. You can use the Zoom command on the View menu to enlarge a chart sheet or worksheet to see it in greater detail. Microsoft Office 2003: Introductory Pasewark & Pasewark

Rename a Worksheet Excel – Lesson 8 l 9 Change the name a worksheet by rightclicking the sheet tab and clicking Rename on the shortcut menu. Microsoft Office 2003: Introductory Pasewark & Pasewark

Preview and Print a Chart Excel – Lesson 8 l 10 l l Preview and print a chart the same way you do a worksheet. Click the Print Preview button to preview the sheet. Click the Print button to send the sheet directly to the printer. Microsoft Office 2003: Introductory Pasewark & Pasewark

Create an Embedded Chart Excel – Lesson 8 l 11 l A chart sheet is an area separate from the Excel worksheet in which a chart is created and stored. An embedded chart is created within a worksheet. Microsoft Office 2003: Introductory Pasewark & Pasewark

Edit a Chart Excel – Lesson 8 l 12 The following areas of a chart may be edited: – – – Chart title Axis Data series Plot area Chart area Microsoft Office 2003: Introductory Pasewark & Pasewark

Summary Excel – Lesson 8 l 13 l l A chart is a graphical representation of worksheet data. Charts may be embedded within a worksheet or created on a chart sheet. The Chart Wizard is a four-step, on-screen guide that helps you prepare a chart from an Excel worksheet. Microsoft Office 2003: Introductory Pasewark & Pasewark

Summary (cont. ) Excel – Lesson 8 l 14 l When you save the worksheet, you will also save the charts you have created from the worksheet. Edit a chart by clicking one of six areas of the chart that accesses a Format dialog box. Microsoft Office 2003: Introductory Pasewark & Pasewark