Microsoft Office Tutorials and References
In Depth Information
Changing the scale of a category axis
value axis and a horizontal category axis, that would put the category axis at the top of the
chart (unless you also select Values In Reverse Order).
Reversing the value-axis scale
You can turn the value-axis scale upside down so that the higher values appear near the
bottom of the chart. You might find this option convenient if all your chart values are
negative and you’re interested primarily in their absolute value. To invert the scale, select Values
In Reverse Order.
Using logarithmic scaling
To use logarithmic scaling, select the Logarithmic Scale check box. If you want to use a base
other than 10, type that base in the box to the right.
In a logarithmic scale, the lowest value is 1. You cannot plot negative and 0 values. If you
apply logarithmic scaling to a chart that includes negative or 0 values, Excel displays an
error message and removes the points that it cannot plot. You can restore those points by
returning to linear scaling.
Applying a scaling factor
To facilitate the plotting of large numbers, Excel lets you scale your value axis in units
ranging from hundreds to trillions. When you choose one of these options, you might also want
to ensure that the Show Display Units Label On Chart check box is selected so that it will be
clear that a scaling factor has been applied.
Changing the display format of a value axis
By default, Excel displays numbers on the value axis in the same format as the worksheet
cells from which those numbers are derived. If you want something different, you can go
back to the worksheet and change the format there. Alternatively, you can click Number
in the Format Axis task pane, and then open the Category drop-down menu. The options
available there are the same as those for formatting worksheet numbers; for details, see
“Formatting in depth” in Chapter 9.
For more about formatting value axes, see “Formatting axes,” in Chapter 20.
Changing the scale of a category axis
Excel recognizes two kinds of category axes—those that have ordinary text labels and those
whose labels are dates. If the axis labels are dates, Excel ordinarily applies time-scaling to it;
that is, it spaces the labels and data according to their temporal positions. To take a simple
Search JabSto ::




Custom Search