HasDisplayUnitLabel Property 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