Graphs and Charts: Delivering a Message - PowerPoint PPT Presentation

1 / 21
About This Presentation
Title:

Graphs and Charts: Delivering a Message

Description:

Know advantages and disadvantages of different chart types ... Pie and Exploded pie charts are effective for displaying proportional relationships ... – PowerPoint PPT presentation

Number of Views:36
Avg rating:3.0/5.0
Slides: 22
Provided by: robert1585
Category:

less

Transcript and Presenter's Notes

Title: Graphs and Charts: Delivering a Message


1
Exploring Microsoft Excel
  • Chapter 4
  • Graphs and Charts Delivering a Message
  • By
  • Robert T. Grauer
  • Maryann Barber

2
Objectives (1 of 2)
  • Know advantages and disadvantages of different
    chart types
  • Distinguish between an embedded chart and one in
    a separate chart sheet
  • Use the ChartWizard
  • Use Drawing toolbar to enhance chart with lines,
    3D shapes and objects

3
Objectives (2 of 2)
  • Differentiate between data series specified in
    rows versus ones in columns
  • Create a compound document consisting of word
    processing, worksheet and a chart

4
Overview
  • Business graphics one of most exciting Windows
    applications
  • Determine message of chart
  • Create charts using Chart Wizard
  • Plot multiple data sets on a single chart
  • Dynamically link a chart to a memo

5
What is a Chart?
  • A graphic representation of data in a worksheet
  • Based on descriptive (text) entries called
    category labels and numeric values called data
    points
  • Data series a grouping of data points

6
Chart Types
  • Always remember to keep it simple and clear
  • Pie and Exploded pie charts are effective for
    displaying proportional relationships
  • Column charts are used for displaying numbers
  • Bar charts show numbers horizontally

7
Pie Charts
8
Column Charts
9
Creating A Chart
  • Select the cells containing your labels and data
    points
  • Use the Chart Wizard a four step process
  • Step one choose a chart type
  • Step two review data series
  • Step three final touches
  • Step four where to store

10
Chart Wizard
11
Finishing the Chart
  • Embedding in a worksheet or separate chart sheet
  • Enhance with Drawing toolbar

12
Hands-On Exercise 1
  • Objective To create and modify a chart to
    embed a chart within a worksheet to enhance a
    chart
  • The AutoSum command
  • Start the Chart Wizard
  • Move and Size the chart
  • Change the worksheet
  • Change the chart type
  • Create the second chart
  • Add a text box
  • Create a 3-D Shape

13
Using the Drawing toolbar
14
Multiple Data Series
  • Decide what message to convey with the chart
  • What do you want to emphasize?
  • Rows versus columns
  • If data series are in rows the Chart Wizard will
    use first row for X axis and use first column for
    legend text
  • If data series are in columns the Chart Wizard
    will use first column for X axis and use first
    row for legend text

15
Stacked Column Charts
  • A column chart that depicts totals by category
    instead of each individual data point
  • Useful when you want to compare totals by category

16
Hands-On Exercise 2
  • Objective To plot multiple data series in the
    same chart to differentiate between data series
    in rows and columns to create multiple charts
    associated with the same worksheet
  • Rename the worksheets
  • The Office Assistant
  • View the data series
  • Copy the chart sheet
  • Change the source data
  • Change the chart type

17
Using Multiple Data Series
18
Object Linking and Embedding
  • Create a document in one application that
    contains objects from another application
  • For example, contain a Word document that
    contains objects from an Excel worksheet
  • Embedded object is stored in the document
  • an Excel chart becomes part of the Word document
  • Linked object is stored in its own file
  • any change in this file is automatically
    reflected in the main document
  • Multitasking the ability to have more than one
    application open at the same time

19
Hands-On Exercise 3
  • Objective To create a compound document
    consisting of a memo, worksheet, and chart
  • Open the software sales document
  • Copy the worksheet
  • Create the link
  • Copy the chart
  • Add the chart
  • Modify the worksheet
  • Update the links
  • The finishing touches

20
Summary (1 of 2)
  • Charts are an easy to understand way to show data
  • Easiest way to create charts is with the Chart
    Wizard
  • Charts can be embedded or stored in a separate
    file
  • Multiple data series may be stored in rows
    columns

21
Summary (2 of 2)
  • OLE enables creation of compound documents
  • Embedding means storing an object within the
    compound document
  • Linking means storing the object in its own
    file, and the compound document uses this file
Write a Comment
User Comments (0)
About PowerShow.com