DisplayUnitLabel.Position (Excel)

Returns or sets the position of the unit label on an axis in the chart. Possible return values are xlChartElementPositionAutomatic - Automatically sets the position of the chart element, xlChartElementPositionCustom - Specifies a specific position for the chart element.

ActiveChart.Axes(1).DisplayUnitLabel.Position = xlChartElementPositionAutomatic