Axis.CategoryType (Excel)

Returns or sets the category axis type. Possible return values are xlAutomaticScale - Excel controls the axis type, xlCategoryScale - Axis groups data by an arbitrary set of categories, xlTimeScale - Axis groups data on a time scale.

You cannot set this property for a value axis.

ActiveChart.Axes(1).CategoryType = xlAutomaticScale