INTRODUCTORY MICROSOFT EXCEL Lesson 8 Worksheet Charts - PowerPoint PPT Presentation

Loading...

PPT – INTRODUCTORY MICROSOFT EXCEL Lesson 8 Worksheet Charts PowerPoint presentation | free to view - id: 1a0d54-ZDc1Z



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

INTRODUCTORY MICROSOFT EXCEL Lesson 8 Worksheet Charts

Description:

Scatter chart. 5. Excel Lesson 8. Microsoft Office 2003: Introductory ... scatter charts. Several types of charts can also be created three-dimensionally. 7 ... – PowerPoint PPT presentation

Number of Views:103
Avg rating:3.0/5.0
Slides: 15
Provided by: willi345
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: INTRODUCTORY MICROSOFT EXCEL Lesson 8 Worksheet Charts


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 (cont.)
  • Preview and print a chart.
  • Create an embedded chart.
  • Edit a chart and change the type of chart.

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

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

6
Identify the Types of Worksheet Charts
  • You can create several types of worksheet charts
  • column charts
  • line charts
  • pie charts
  • scatter charts
  • Several types of charts can also be created
    three-dimensionally.

7
Create a Chart Sheet and Save 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 and Use Zoom
  • 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.

9
Rename a Worksheet
  • Change the name a worksheet by right-clicking the
    sheet tab and clicking Rename on the shortcut
    menu.

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

11
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.

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

13
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.

14
Summary (cont.)
  • 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.
About PowerShow.com