Microsoft Office Tutorials and References
In Depth Information
Creating a Basic Chart
Chapter 13
Generating Excel Charts
Tick marks Data labels Gridlines
Data series Plot area Legend
Component
Description
Category
A single grouping of data on
the Category axis. The Category
is identified in the legend.
Vertical or
A scale representing the zero
Value Axis
or the lowest and highest
numbers in the plotted data.
The Value axis is usually located
on the left side on a column
chart or on the bottom on a
bar chart.
Vertical
A descriptive name for the
Axis Title
values. By default, a vertical axis
label is not added in a basic
chart, but you can add one later
manually or by using the Chart
Wizard.
Figure 13-2
Excel chart elements.
Table 13-1 Chart Components
Legend
The box, usually located on
the right, identifies the patterns
or colors that are assigned to
the chart data series. Notice in
Figure 13-3 how the legend
explains that one color
represents January, another color is
for February, and the third
color is for March.
Component
Description
Title
A descriptive name for the
overall chart. By default, titles
are not added in a basic chart,
but you can add them later
manually or by using the
Chart Wizard.
Horizontal or
Column or row headings from
Tick marks
The small extensions of lines
that appear outside of the gray
area that represent divisions of
the value or category axis.
Category Axis
your selected data, which Excel
uses for Category axis names. In
a column chart, the categories
display along the bottom. In
other charts (such as a bar
chart), the category axis
displays along the left side.
Gridlines
These lines extend from the
tick marks across the chart
area to allow you to easily
view and evaluate data.
Horizontal
A descriptive name for the
Axis Title
Category axis. By default, a
category label is not added in
a basic chart, but you can add
one later manually or with the
Chart Wizard.
Series
Excel uses the worksheet cell
values to generate the series.
Each element, called a data
marker, represents a single
(continued)
Search JabSto ::




Custom Search