CategoryType Property

  • Article

XlCategoryType

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

expression.CategoryType

*expression   * Required. An expression that returns one of the objects in the Applies To list.

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

Applies to | Axis Object

See Also | BaseUnit Property | BaseUnitIsAuto Property | MajorUnitScale Property | MinorUnitScale Property | Type Property