Axis.DisplayUnitLabel Property (Excel)

Published: July 16, 2012

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

expression .DisplayUnitLabel

expression A variable that represents an Axis object.

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

Community Additions

© 2014 Microsoft