Axis.CategoryType (PowerPoint)

Returns or sets the category axis type. Possible return values are xlAutomaticScale - Word 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.

ActivePresentation.Slides(1).Shapes(1).Chart.Axes(1).CategoryType = xlAutomaticScale