Microsoft Office 2003- Illustrated Introductory, Second Edition

1
Microsoft Office 2003- Illustrated Introductory,
Second Edition
Working

• with Charts

2
Objectives

• Plan and design a chart
• Create a chart
• Move and resize a chart
• Edit a chart

3
Objectives

• Format a chart
• Enhance a chart
• Annotate and draw on a chart
• Preview and print a chart

4
Unit Introduction

• Worksheets are not always the best way to present
  data to others
• Information in a range or worksheet can be
  displayed in a chart
• Charts allow you to communicate the relationships
  in worksheet data using pictures

5
Planning and Designing a Chart

• Chart planning guidelines
• Determine purpose of chart
• Identify data relationships
• Determine results with chart type
• Identify worksheet data
• Sketch the chart and decide on chart elements

6
Planning and Designing a Chart
Common chart types
7
Planning and Designing a Chart (cont.)

• Chart elements
• The horizontal axis (x-axis) is also called the
  category axis
• The vertical axis (y-axis) is also called the
  value axis
• Area inside the axis is called the plot area
• The scale of measure on the y-axis is identified
  by tick marks
• A data point is the value in a cell
• A data marker represents the data point in the
  chart
• A group of related data points is a data series

8
Planning and Designing a Chart (cont.)
Data series
Tick mark
Plot area
Category (y) axis
Data marker
Category (x) axis
9
Creating a Chart

• To create a chart, first select a range of data
• Use the Excel Chart Wizard to create a chart
• Choose the chart type
• Choose the data to chart and how it appears
• Add chart options
• Determine chart placement
• Can create a chart sheet, a separate sheet
  containing just the chart

10
Creating a Chart (cont.)
Legend
Column labels
Row labels
Data range
Chart object
Y-axis
X-axis
11
Moving and Resizing a Chart

• A chart is a graphic, or drawn object, and is not
  located in a specific cell or range
• An object is an independent element on a
  worksheet
• An object can be moved anywhere on the worksheet
  without affecting formulas or data
• Resize a chart by moving a selection handle move
  a chart by dragging it

12
Moving and Resizing a Chart (cont.)
Selection handle
Common mouse pointers
13
Editing a Chart

• Changing data values in the worksheet
  automatically updates the chart

Change value here
see data marker change here
14
Editing a Chart (cont.)

• Rotating a 3-D chart
• Other data series in the same chart can obscure
  columns or bars
• Rotate the chart to get a better view by dragging
  the Corners object

Corners object
15
Formatting a Chart

• Change a charts appearance by formatting it
• The horizontal and vertical lines in a chart are
  called gridlines

Change data series color
Gridline
16
Enhancing a Chart

• Create titles, add graphics, or add background
  color

Drop shadow
Gridline
Value axis title
Category axis title
17
Enhancing a Chart (cont.)

• Changing text alignment in charts
• Change text alignment of axis text to fit better
  in plot area
• Double-click the axis to be modified, click the
  Alignment tab in the Format Axis dialog box, then
  change the degree number

18
Annotating and Drawing on a Chart

• A text annotation is a label that you add to a
  chart to further describe data
• Use lines and arrows to point out exact locations
  you want to emphasize
• Typing text in the formula bar creates annotation
  text

19
Annotating and Drawing on a Chart (cont.)
Annotation text
Arrow
20
Annotating and Drawing on a Chart (cont.)

• Exploding a pie slice
• Emphasize a pie slice in a pie chart
• Click and drag the desired pie slice

Exploded pie slice
21
Previewing and Printing a Chart

• Before printing, its a good idea to preview your
  chart
• When you preview a chart, you see a copy of the
  chart exactly as it will appear on paper
• The landscape page orientation runs text the long
  way on the page

22
Previewing and Printing a Chart (cont.)
Landscape page orientation
23
Summary

• Plan your chart
• Create the chart
• Resize, move, and edit the chart
• Enhance the chart
• Preview and print the chart