HasDisplayUnitLabel Property

Microsoft Excel Visual Basic

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