Microsoft Office Tutorials and References
In Depth Information
Setting Axis Scale Options
In most cases, you should leave this setting at Auto. You can also use this fea-
ture to place tick marks on the axes between the labels of the major units.
You can set axis options in the Format Axis task pane, including the axis scale
Click Auto to return
any setting to being
Set the minimum and
maximum values for
the value axis.
Specify the units
by which the axis
4. (Optional) If you want to change where the axes cross, select Axis Value in
the Horizontal Axis Crosses section, and then enter a numeric value in its box.
Changing this value recalculates the numbers in the Bounds and Units sections that
are set to Auto.
5. (Optional) If you want to activate any of these special features, select their
Logarithmic Scale. Rarely used by ordinary folks, this check box recalculates
the Minimum, Maximum, Major, and Minor values according to a power of 10 for
the value axis, based on the range of data. (If this explanation doesn’t make
any sense to you, then you’re not the target audience for this feature.)
Values in Reverse Order. This check box turns the scale backward so that the
greater values appear at the bottom or left.