Display/Show related procedures in class Axis (Word VBA)

This page presents procedures from class Axis related to the theme Display/Show: DisplayUnit, DisplayUnitCustom and DisplayUnitLabel

DisplayUnit

Returns or sets the unit label for the value axis.

Possible Values are xlHundredMillions - Hundreds of millions, xlHundreds - Hundreds, xlHundredThousands - Hundreds of thousands, xlMillionMillions - Millions of millions, xlMillions - Millions, xlTenMillions - Tens of millions, xlTenThousands - Tens of thousands, xlThousandMillions - Thousands of millions, xlThousands - Thousands.

Using unit labels when charting large values makes your tick-mark labels easier to read. For example, if you label your value axis in units of hundreds, thousands, or millions, you can use smaller numeric values at the tick marks on the axis.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.Axes(xlValue) 
 .DisplayUnit = xlHundreds 
 .HasTitle = True 
 .AxisTitle.Caption = "Rebate Amounts" 
 End With 
 End If 
End With

DisplayUnitCustom

If the value of the DisplayUnit property is xlCustom, returns or sets the value of the displayed units.

The value of this property must be from 0 through 10E307. Using unit labels when charting large values makes your tick-mark labels easier to read. For example, if you label your value axis in units of hundreds, thousands, or millions, you can use smaller numeric values at the tick marks on the axis.

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.Axes(xlValue) 
 .DisplayUnit = xlCustom 
 .DisplayUnitCustom = 500 
 .HasTitle = True 
 .AxisTitle.Caption = "Rebate Amounts" 
 End With 
 End If 
End With

DisplayUnitLabel

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

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 With .Chart.Axes(xlValue).DisplayUnitLabel 
 .Caption = "Millions" 
 .AutoScaleFont = False 
 End With 
 End If 
End With