Axis.Type (PowerPoint)
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.
ActiveWindow.RangeFromPoint.Chart.Axes(1).Type = xlCategory