MinorUnitScale Property

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