Microsoft Office Tutorials and References
In Depth Information
Working with Chart Axes
Another option in the Format Axis dialog box is Values in Reverse Order. The top chart in Figure 7-21
uses default axis settings. The bottom chart uses the Values in Reverse Order option, which reverses
the scale’s direction. Notice that the category axis is at the top. If you would prefer that it remain at
the bottom of the chart, select the Maximum Axis Value option for the Horizontal Axis Crosses setting.
Figure 7-21: The bottom chart uses the Values in Reverse Order option.
If the values to be plotted cover a very large range, you may want to use a logarithmic scale for the
value axis. A log scale is most often used for scientific applications. Figure 7-22 shows two charts. The
top chart uses a standard scale, and the bottom chart uses a logarithmic scale. Note that the base is
10, so each scale value in the chart is 10 times greater than the one below it. Increasing the base unit
to 100 would result in a scale in which each tick mark value is 100 times greater than the one below.
If your chart uses very large numbers, you may want to change the Display Units settings. Figure 7-23
shows a chart that uses very large numbers. The lower chart uses the Display Units as Millions setting,
with the option to Show Display Units Label on Chart. Excel inserted the label “Millions,” which was
edited to display as “Millions of Miles.”