Microsoft Office Tutorials and References
In Depth Information
Reformatting the Vertical Axis
NOTE: You can also access the gradient and other options with the mini-toolbar, by clicking the
arrow to the right of those toolbar buttons accompanied by the arrow. In our example, if you click
the arrow by the fill button, you’ll see what’s shown in Figure 6–30.
Figure 6–30. Note the gradient option.
NOTE: If you’ve introduced all kinds of formatting variations into the chart and are beginning to
have second thoughts about it all, return to the Current Selection button group, select the
changed object(s) in sequence, and click Reset to Match Style. All the default formatting settings
will be restored.
Reformatting the Vertical Axis
Now that we’ve talked about some of those color-based formatting options, we need to
turn to some different kinds of formatting possibilities. Let’s turn to the vertical (value)
axis, the leftmost area of the chart, which lists the values against which the chart data is
measured. When you devise a chart, Excel makes an educated guess as to which values
best characterize the data. In our chart we see a scale of values running from 0 to 100 at
10-point intervals, reflecting the test scores we’re charting.
But you can change the scale. For example, you could space the intervals differently—
say, at 5-point intervals, so that the 0 to 100 scale could display 0, 5, 10, 15, and so on,
instead.
Say you wanted the value axis to read 0, 20, 40, 80, and 100.
1.
Right-click right atop the axis and click Format Axis, and you’ll be taken to
the dialog shown in Figure 6–31.
 
Search JabSto ::




Custom Search