Axis.MajorUnitScale Property (Excel)
Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.
Syntax
expression .MajorUnitScale
expression A variable that represents an Axis object.
Remarks
XlTimeUnit can be one of these XlTimeUnit constants. |
xlMonths |
xlDays |
xlYears |
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