Microsoft Office Tutorials and References
In Depth Information
Working with Chart Axes
Figure 7-25: Excel recognizes the dates and creates a time-based category axis.
Figure 7-26: The previous chart, using a standard category axis.
A time-scale axis option is available only for the category axis (not the value axis).
When a category axis uses dates, the Axis Options tab of the Format Axis dialog box lets you specify
the Base Unit, the Major Unit, and the Minor Unit — each in terms of days, months, or years.
If you need a time-scale axis for smaller units (such as hours), you need to use a scatter chart. That’s
because a date-scale axis treats all values as integers. Therefore, every time value is plotted as
midnight of that day. Figure 7-27 shows a scatter chart that plots scheduled versus actual arrival times for
flights. Note that both of the value axes display times, in one-hour increments.