XlTimeUnit can be one of these XlTimeUnit constants. |
xlMonths |
xlDays |
xlYears |
expression.MajorUnitScale
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets the category axis to use a time scale and sets the major and minor units.
With Charts(1).Axes(xlCategory)
.CategoryType = xlTimeScale
.MajorUnit = 5
.MajorUnitScale = xlDays
.MinorUnit = 1
.MinorUnitScale = xlDays
End With