Time series plots and area graphs use a time series scale for the x-axis. Time units are specified in the Time tab of the Time/Scale subdialog box. The time series scale can be:
- Calendar units (days, months, quarters, or years)
- Clock units (days, hours, minutes, or seconds)
You can customize time units, start times, and increment times for index, calendar, and clock scales. See the chart below for ranges and default start values. The default increments are 1 unit.
Time scale |
Time unit |
Valid values |
Default start value |
Index |
Generic |
All integers |
1 |
Calendar |
Day |
1 to 31 (depending on the month) |
Current day |
|
Month |
1 to 12 |
Current month |
|
Quarter |
1 to 4 |
Current quarter |
|
Year |
Valid 4-digit years |
Current year |
Clock |
Second |
0 to 59 |
0 |
|
Minute |
0 to 59 |
0 |
|
Hour |
0 to 23 |
0 |
Example of x-axis with a stamp column |
Example of x-axis with two calendar units - month and year |