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