Microsoft Office Tutorials and References
In Depth Information
Using time-scale axes
Display Units: If your values consist of large numbers, you may wish
to display the axis values in terms of a unit. For example, you might
want to display values in millions, so a scale value of 5,000,000 would
be displayed as 5. If you would like the unit name to appear on the chart,
select the check box labeled Show Display Units Label on Chart. This
option is not available in versions prior to Excel 2000.
Values in Reverse Order: When this option is selected, the scale values
extend in the opposite direction. For a value axis, for example, selecting
this option displays the smallest scale value at the top and the largest at
the bottom (the opposite of how it normally appears).
Type Axis Crosses at Maximum Value: When this option is selected, the
axis is positioned at the maximum value of the perpendicular axis (nor-
mally, the axis is positioned at the minimum value of the perpendicular
axis). The exact wording of this option ( Axis Type ) varies, depending on
which axis is selected.
Using time-scale axes
When you create a chart, Excel is smart enough to know whether your category
axis contains date or time values. If so, it creates a time-series chart. Figure 4-24
shows a simple example. Column A contains dates, and column B contains the
values plotted in the column chart. The data consists of values for only 10 dates, yet
Excel created the chart with 31 intervals on the category axis. It recognized that the
category axis values were dates, and created an equal-interval scale.
Figure 4-24: Excel recognizes the dates and creates a time-based category axis.
OVERRIDING A TIME-SCALE AXIS
If you would like to override Excel’s decision to use a time-based category axis, you
need to access the Axes tab of the Chart Options dialog box. There, you’ll discover
Search JabSto ::




Custom Search