# Excel 2007 Chart by stk10617

VIEWS: 40 PAGES: 20

• pg 1
```									Microsoft Excel 2007 -
Illustrated

Enhancing Charts
Objectives
• Customize a data series
• Change a data source and add data
labels
• Format the axes of a chart
• Add a data table to a chart

Microsoft Office Excel 2007 - Illustrated   2
Objectives
•     Rotate a chart
•     Enhance a chart with WordArt
•     Add a picture to a chart
•     Identify data trends

Microsoft Office Excel 2007 - Illustrated   3
Customizing a Data Series

• A data series is the information,
usually numbers or values, that Excel
plots on a chart

Microsoft Office Excel 2007 - Illustrated      4
Changing a Data Source and
• Descriptive text, called a data label,
appears above a data marker in a
chart

Microsoft Office Excel 2007 - Illustrated       5
Changing a Data Source and

Data label

Microsoft Office Excel 2007 - Illustrated   6
Formatting the Axes of a Chart

• Excel plots and formats chart data
and places the chart axes within the
chart’s plot area
• Data values in two-dimensional charts
are plotted on the y-axis and categories
are plotted on the x-axis
• A scale is created for the value (y) axis
that is based on the highest and lowest
values in the data series

Microsoft Office Excel 2007 - Illustrated                          7
Formatting the Axes of a Chart
(cont.)
• Three axes are generated in three-
dimensional charts; x-axis (category),
z-axis (value), and y-axis (chart depth)
• Z-axis usually contains the scale for the
chart
• Override Excel default formats for chart
axes using the Format Axis dialog box

Microsoft Office Excel 2007 - Illustrated                      8
Formatting the Axes of a Chart
(cont.)
Value (z)
axis

Maximum
value

Minimum
value

Microsoft Office Excel 2007 - Illustrated   9
Adding a Data Table to a Chart

• A data table is a grid containing the
chart data, attached to the bottom of
a chart
• Data tables are useful because they
highlight the data you used to generate
the chart

Microsoft Office Excel 2007 - Illustrated                 10
Adding a Data Table to a Chart
(cont.)

Data table

Microsoft Office Excel 2007 - Illustrated   11
Rotating a Chart

• By rotating a 3-D chart, you can
improve the visibility of the chart data
• Depth can be increased to improve
visibility of chart data

Microsoft Office Excel 2007 - Illustrated     12
Rotating a Chart (cont.)

Increased
depth and
rotation

Microsoft Office Excel 2007 - Illustrated   13
Enhancing a Chart with
WordArt
• Enhance a chart or worksheet by
• Format WordArt using 3-D effects and
• WordArt text is considered an object

Microsoft Office Excel 2007 - Illustrated              14
Enhancing a Chart with
WordArt (cont.)

WordArt text

Microsoft Office Excel 2007 - Illustrated   15
Adding a Picture to a Chart

• Enhance a chart by adding a picture
to the data markers, chart area, plot
area, legend, or chart walls and
floors

Microsoft Office Excel 2007 - Illustrated      16
Adding a Picture to a Chart
(cont.)

Picture
back wall

Microsoft Office Excel 2007 - Illustrated   17
Identifying Data Trends

• Creating a trendline
• Trendlines graphically represent data
trends
• Emphasize patters in data
• Predict future data based on past
trends

Microsoft Office Excel 2007 - Illustrated               18
Identifying Data Trends (cont.)

U.S.
Trendline

U.K.
Trendline

Microsoft Office Excel 2007 - Illustrated   19
Summary

• Customize data series
• Format chart axes and add data
tables
• Rotate a chart
• Use WordArt to enhance charts