Share via

CategoryType Property

  • Article

Returns or sets the category axis type. Read/write

.

XlCategoryType can be one of these XlCategoryType constants.
xlCategoryScale
xlAutomaticScale
xlTimeScale

expression.CategoryType

Remarks

You cannot set this property for a value axis.

Example

This example sets the category axis on the chart to use a time scale, with months as the base unit.

  With myChart
    With .Axes(xlCategory)
        .CategoryType = xlTimeScale
        .BaseUnit = xlMonths
    End With
End With

See Also