DisplayUnit Property Example
This example sets the units displayed on the value axis in Chart1 to hundreds.
With Charts("Chart1").Axes(xlValue) .DisplayUnit = xlHundreds .HasTitle = True .AxisTitle.Caption = "Rebate Amounts" End With