Share via

Axis.MinorUnitScale Property (Word)

  • Article

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

Version Information

Version Added: Word 2007

Syntax

expression .MinorUnitScale

expression A variable that represents an Axis object.

Remarks

MinorUnitScale can be one of the following XlTimeUnit constants:

  • xlMonths

  • xlDays

  • xlYears

Example

The following example sets the category axis to use a time scale and sets the major and minor units.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.Axes(xlCategory) 
 .CategoryType = xlTimeScale 
 .MajorUnit = 5 
 .MajorUnitScale = xlDays 
 .MinorUnit = 1 
 .MinorUnitScale = xlDays 
 End With 
 End If 
End With

See Also

Concepts

Axis Object

Axis Object Members