Microsoft Office Tutorials and References
In Depth Information
Value Axis versus Category Axis
Scale: Allows changes to the minimum and maximum axis values, units
for major and minor gridlines, and several other properties.
Font: Allows changes to the font and font style used for the axis labels.
Because it’s not possible to select a single axis label, the font formatting
applies to all labels on the axis. In addition, it’s not possible to apply special
formatting to individual characters (for example, superscript formatting).
Number: Allows changes to the number format used to display numerical
axis labels.
Alignment: Allows changes to the orientation for the axis labels.
All aspects of axis formatting are covered in the sections that follow.
Value Axis versus Category Axis
Before getting into the details of formatting, it’s important to understand the
difference between a category axis and a value axis. A category axis displays arbitrary
text, whereas a value axis displays numerical intervals. Figure 4-18 shows a simple
column chart with two series. The horizontal category axis displays labels that
represent the categories. The vertical value axis, on the other hand, represents a
numerical scale.
Figure 4-18: The category axis displays arbitrary labels, whereas the value
axis displays a numerical scale.
In this example, the category labels happen to be text. Alternatively, the categories
could be numbers. Figure 4-19 shows the same chart after replacing the category
labels with numbers. Even though the chart becomes fairly meaningless, it should
be clear that the category axis does not display a true numeric scale. The numbers
displayed are completely arbitrary, and the chart itself was not affected by changing
these labels.
Search JabSto ::




Custom Search