HasDisplayUnitLabel Property

Microsoft Excel Visual Basic

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