MinorUnitScale Property
Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.
| XlTimeUnit can be one of these XlTimeUnit constants. |
| xlMonths |
| xlDays |
| xlYears |
expression.MinorUnitScale
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