Axis.CategoryType Property

  • Article
Word Developer Reference

Returns or sets the category axis type. Read/write XlCategoryType.

Version Information
 Version Added:  Word 2007

Syntax

expression.CategoryType

expression   A variable that represents an Axis object.

Remarks

You cannot set this property for a value axis.

Example

The following example sets the category axis for the first chart in the active document to use a time scale, using months as the base unit.

Visual Basic for Applications 
  With ActiveDocument.InlineShapes(1)
    If .HasChart Then
        With .Chart.Axes(xlCategory)
            .CategoryType = xlTimeScale
            .BaseUnit = xlMonths
        End With
    End If
End With

See Also