MajorUnitScale Property [Excel 2003 VBA Language Reference]

  • Article

XlTimeUnit

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

Applies to | Axis Object

See Also | BaseUnit Property | MajorUnit Property | MajorUnitIsAuto Property | MinorUnit Property | MinorUnitIsAuto Property | MinorUnitScale Property