Microsoft Office Tutorials and References
In Depth Information
Setting Axis Scale Options
A change to the values of the axis scale makes it easier to see the differences between val-
To set the scale (bounds) for an axis, follow these steps:
1. Right-click the axis on the chart that contains the values you are plotting, and
click Format Axis. (This is typically the vertical axis on a column chart.)
The Format Axis task pane appears, displaying the Axis Options, as shown in
2. If you do not want the automatic value for one of the measurements, enter a
different number in its text box under Bounds. To change your mind and go back
to automatic settings for these, click Auto next to the text box.
Minimum is the starting number. The usual setting is 0, as shown in
Figure 12.27, although in Figure 12.28, it is set to 2.8.
Maximum is the top number. This number is 4 in both Figure 12.27 and
3. If you want the units on the axis to display differently, change the values in
their boxes under Units. To change your mind and go back to automatic settings
for these, click Auto next to the box.
Major determines the axis text. It is also the unit by which gridlines stretch out
across the back wall of the chart. In Figure 12.27, gridlines appear at increments
of 0.5 million units; in Figure 12.28, they appear by 0.2 million units.
Minor is the interval of smaller gridlines between the major ones. Most charts
look better without minor units because they can make a chart look cluttered.