Microsoft Office Tutorials and References
In Depth Information
Parts of a Chart
Refer to the chart in Figure 5-5 as you read the following description of the chart’s elements.
Figure 5-5: Parts of a chart.
This particular chart is a combination chart that displays both columns and a line. The chart has two
data series: Income and Profit Margin. Income is plotted as vertical columns, and the Profit Margin is
plotted as a line with square markers. Each bar (or marker on the line) represents a single data point
(the value in a cell).
The chart has a horizontal axis, known as the category axis . This axis represents the category for each
data point (January, February, and so on). This axis doesn’t have a label because the category units
Notice that this chart has two vertical axes. These are known as value axes, and each one has a
different scale. The axis on the left is for the column series (Income), and the axis on the right is for the line
series (Profit Margin).
The value axes also display scale values. The axis on the left displays scale values from 0 to 250,000, in
major unit increments of 50,000. The value axis on the right uses a different scale: 0 percent to 14
percent, in increments of 2 percent. For a value axis, you can command the minimum and maximum
values, as well as the increment value.
A chart with two value axes is appropriate because the two data series vary dramatically in scale. If
the Profit Margin data were to be plotted using the left axis, the line would not even be visible.