This documentation is archived and is not being maintained.

Axis.MinorUnitScale Property

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

Syntax

expression.MinorUnitScale

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



Show: