Axis.MajorUnitScale Property

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.

Visual Basic for Applications
`With Charts(1).Axes(xlCategory) .CategoryType = xlTimeScale .MajorUnit = 5 .MajorUnitScale = xlDays .MinorUnit = 1 .MinorUnitScale = xlDays End With`

major major unit scale MajorUnit majorunitscale majorunitscale property

Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.