Microsoft Office Tutorials and References
In Depth Information
Changing the scale of a category axis
Figure 19-5 Changing the base unit to Months creates a monthly open-high-low-close chart.
Figure 19-6 Switching the base unit to Years creates yearly bars.
Unfortunately, Excel offers only three base unit choices—Days, Months, and Years. Thus,
if your data provides, say, hourly price points, you will get a daily chart regardless. If you
prefer an ordinary line chart showing hourly price progressions, your recourse is to turn off
date scaling in favor of a text category axis.