INTRODUCTORY MICROSOFT EXCEL Lesson 8 - PowerPoint PPT Presentation

Loading...

PPT – INTRODUCTORY MICROSOFT EXCEL Lesson 8 PowerPoint presentation | free to download - id: 7bb232-YzMxZ



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

Description:

INTRODUCTORY MICROSOFT EXCEL Lesson 8 Worksheet Charts Objectives Identify the purpose of charting worksheet data. Identify the types of worksheet charts. – PowerPoint PPT presentation

Number of Views:56
Avg rating:3.0/5.0
Slides: 26
Provided by: Willi739
Learn more at: http://dlhscomputers.wikispaces.com
Category:

less

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

Title: INTRODUCTORY MICROSOFT EXCEL Lesson 8


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
  • Data series
  • Embedded chart
  • Image handles
  • Line chart
  • Pie chart
  • Scatter chart
  • Axis
  • Chart
  • Chart sheet
  • Chart Wizard
  • Column chart
  • Data labels

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
Increases and decreases are easier to see in a
chart
7
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.

8
Line Chart Pie Chart
  • For trends over time Parts of a whole

9
Scatter Chart
  • Relationship between 2 categories

10
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.
  • To create a chart, InsertChart or click Chart
    Wizard button

11
Title Chart Area
  • Plot Area Gridline
  • Axis Title Legend
  • Data Label
  • Data Series Axis Axis Label

12
Chart Options
13
Chart Wizard
14
Titles
15
New Sheetor Embedded
  • New
  • Sheet

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

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

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

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

20
Embedded 3D Pie Chart
21
Edit a Chart
  • The following areas of a chart may be edited
  • Chart title
  • Axis title
  • Axis
  • Data series
  • Plot area
  • Chart area

22
Editing a ChartFont Color Type, Column Color
23
Editing
  • Charts

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

25
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