Graphs and Charts: Delivering a Message

1
Exploring Microsoft Excel

• Chapter 4
• Graphs and Charts Delivering a Message

2
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

3
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

4
Pie Charts
5
Column Charts
6
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

7
Chart Wizard
8
Finishing the Chart

• Embedding in a worksheet or separate chart sheet
• Enhance with Drawing toolbar

9
Using the Drawing toolbar
10
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

11
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

12
Using Multiple Data Series
13
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