Axis.DisplayUnitLabel Property

  • Article
Excel Developer Reference

Returns the DisplayUnitLabel object for the specified axis. Returns null if the HasDisplayUnitLabel property is set to False. Read-only.

Syntax

expression.DisplayUnitLabel

expression   A variable that represents an Axis object.

Example

This example sets the label caption to "Millions" for the value axis in Chart1, and then it turns off automatic font scaling.

Visual Basic for Applications 
  With Charts("Chart1").Axes(xlValue).DisplayUnitLabel
    .Caption = "Millions"
    .AutoScaleFont = False
End With

See Also