Share via


Axis.MinorUnitScale Property (Excel)

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.

With Charts(1).Axes(xlCategory) 
 .CategoryType = xlTimeScale 
 .MajorUnit = 5 
 .MajorUnitScale = xlDays 
 .MinorUnit = 1 
 .MinorUnitScale = xlDays 
End With

See Also

Concepts

Axis Object

Axis Object Members