Microsoft Office Tutorials and References
In Depth Information
Changing the scale of a category axis
On a time-scaled chart, Excel plots data in chronological order even if it’s not sorted by
date on the worksheet. We don’t recommend randomizing your data, but it’s
interesting to know that the Excel charting engine doesn’t object.
Changing the base unit
On charts with date axes, Excel can plot data points only at intervals of the base unit.
The available base units are Days, Months, and Years. Excel decides what base unit to use
according to the smallest difference in value between points in your source data. In other
words, the program usually knows what to do and usually gets it right. You might
occasionally find it convenient to overrule, however.
For example, Figure 19-4 plots daily price data using the automatically determined base
unit of Days. Switching the base unit to Months or Years (Figures 19-5 and 19-6,
respectively) turns the simple daily line chart into an open-high-low-close chart that shows the
variation of prices over larger time intervals.
Figure 19-4 With the base unit set to its automatically determined value, Days, Excel generates a
simple line chart of daily prices.