Axis.Type (Word)

Returns the axis type. Possible return values are xlCategory - Axis displays categories, xlSeriesAxis - Axis displays data series, xlValue - Axis displays values.

When you use this property for the horizontal axis of scatter charts, xlCategory will be returned as the axis type.

ActiveDocument.Background.Chart.Axes(1).Type = xlCategory