Axis.DisplayUnitLabel Property (Excel)
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.
With Charts("Chart1").Axes(xlValue).DisplayUnitLabel
.Caption = "Millions"
.AutoScaleFont = False
End With