Axis.HasDisplayUnitLabel Property (Excel)
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.
Syntax
expression .HasDisplayUnitLabel
expression A variable that represents an Axis object.
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