Microsoft Office Tutorials and References
In Depth Information
Scale tab in the Format Axis dialog box
click the Auto
check boxes to
allow Excel to
scale the axis
sc a le values for
the selected axis
click to choose
the units to
apply to the
There are four values that comprise the scale: the minimum, maximum, major unit, and
minor unit. The minimum and maximum values are the smallest and largest tick marks
that appear on the axis. The major unit is the increment between the scale’s major tick
marks . The chart also has a second set of tick marks, called minor tick marks , that may or
may not be displayed. The difference between major and minor tick marks is that axis val-
ues appear next to major tick marks, whereas no values appear next to minor tick marks.
In the current chart, the scale that Excel displayed ranges from 0 to 2,500,000 in incre-
ments of 500,000. The minor tick mark increment is 100,000, but these tick marks are not
displayed on the axes. Alicia wants to reduce the increment value to 250,000 in order to
show more detail on the chart. Then she wants to change the display units from none to
To revise the y-axis scale:
1. Double-click the current entry in the Major unit box, and then type 250000 . Note that
when you manually change a scale value its Auto check box is automatically deselected.
2. Click the Display units list arrow, and then select Thousands in the list.
3. Make sure that the Show display units label on chart check box is selected, and then click
the OK button. Figure 4-31 shows the revised y-axis scale.