Microsoft Office Tutorials and References
In Depth Information
Changing the scale of a value axis
Changing the scale of a value axis
The easiest way to manipulate the scale of a value axis is to double-click it. That brings up
the Format Axis task pane, shown in Figure 19-3. (The values exemplified in Figure 19-3 are
derived from the chart shown in Figure 19-1 earlier in this chapter.)
Click here to display Axis Options
Figure 19-3 Double-clicking an axis displays its formatting task pane, in which, among other
things, you can adjust the axis’s scale.
By entering new values in the Minimum and Maximum text boxes, you can override Excel’s
default choice of axis boundaries.
Changing the positions of tick marks and gridlines
The Major and Minor boxes below the heading Units determine the spacing between tick
marks—and hence between gridlines. If your axis labels or your gridlines are too close
together, type new values in those boxes. The Minor Units value is relevant only if you
choose to display minor tick marks.
Changing the point where axes intersect
By default, axes intersect at the minimum value on the vertical axis scale. You can move the
intersection to a different point by typing a new value in the box next to Axis Value, below
the heading Horizontal Axis Crosses. You can also move the intersection to the highest
point on the value axis by selecting Maximum Axis Value. On a typical chart with a vertical
Search JabSto ::

Custom Search