Share via

Axis.HasDisplayUnitLabel Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  With Charts("Chart1").Axes(xlValue)
    .DisplayUnit = xlCustom
    .DisplayUnitCustom = 500
    .AxisTitle.Caption = "Rebate Amounts"
    .HasDisplayUnitLabel = False
End With

See Also