CategoryType Property

Applies To

Axis object.

Description

Returns or sets the category axis type. Can be one of the following XlCategoryType constants: xlCategoryScale, xlTimeScale, or xlAutomaticScale. Read/write Long.

Remarks

You cannot set this property for a value axis.

See Also

BaseUnit property, BaseUnitIsAuto property, MajorUnitScale property, MinorUnitScale property, Type property.

Example

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

With Worksheets(1).ChartObjects(1).Chart
    With .Axes(xlCategory)
        .CategoryType = xlTimeScale
        .BaseUnit = xlMonths
    End With
End With