1 / 13

INTRODUCTORY MICROSOFT EXCEL Lesson 8 – Worksheet Charts

INTRODUCTORY MICROSOFT EXCEL Lesson 8 – Worksheet Charts. Objectives. 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. Objectives.

wbush
Download Presentation

INTRODUCTORY MICROSOFT EXCEL Lesson 8 – Worksheet Charts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. INTRODUCTORY MICROSOFT EXCELLesson 8 – Worksheet Charts

  2. Objectives • 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.

  3. Objectives • Preview and print a chart. • Create an embedded chart. • Edit a chart and change the type of chart.

  4. Axis Chart Chart sheet Chart Wizard Column chart Data labels Data series Embedded chart Image handles Line chart Pie chart Scatter chart Terms Used in This Lesson

  5. Identify the Purpose of Charting Worksheet Data • A chartis a graphical representation of data contained in a worksheet. • Charts make the data of a worksheet easier to understand.

  6. See Figure 8-3 in student book, Charts Available in Excel Identify the Types of Worksheet Charts • You can create a number of types of worksheet charts: • column charts • line charts • pie charts • scatter charts • Several types of charts can also be created three-dimensionally.

  7. Saving a Chart • A chart created from a worksheet is considered part of that worksheet. • When you save the worksheet, you will also save the charts.

  8. Switch Between Charts and Worksheets, Zoom, and Rename a Chart • 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. • Change the name of a chart sheet by right-clicking the sheet tab and clicking Rename on the shortcut menu.

  9. Preview and Print a Chart • You 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.

  10. See Figure 8-12 in student book, Creating an embedded chart Create an Embedded Chart • 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.

  11. Edit a Chart • The following areas of a chart may be edited: • Chart title • Axis title • Axis • Data series • Plot area • Chart area

  12. Summary • 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.

  13. Summary • When you save a worksheet, you will also save any 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.

More Related