HasDisplayUnitLabel Property
True if the label specified by the DisplayUnit or DisplayUnitCustom property is displayed on the specified axis. The default value is True. Read/write Boolean.
Example
This example sets the units on the value axis in Chart1 to increments of 500 but keeps the unit label hidden.
With Charts("Chart1").Axes(xlValue)
.DisplayUnit = xlCustom
.DisplayUnitCustom = 500
.AxisTitle.Caption = "Rebate Amounts"
.HasDisplayUnitLabel = False
End With