Axis.MajorUnitScale Property

  • Article
Word Developer Reference

Returns or sets the major 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.MajorUnitScale

expression   A variable that represents an Axis object.

Remarks

MajorUnitScale can be one of the following XlTimeUnit constants:

  • xlMonths
  • xlDays
  • xlYears

Example

The following example sets the category axis on the first chart in the active document to use a time scale and sets the major and minor units.

Visual Basic for Applications 
  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