Axis.Type procedure builder

Axis.Type (Excel)

Returns an XlAxisType value that represents the Axis type.

xlCategory - Axis displays categories, xlSeriesAxis - Axis displays data series, xlValue - Axis displays values.

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

ActiveChart.Axes(1).Type = xlCategory