Axis.DisplayUnit Property

Definition

Returns or sets the unit label for the value axis.

public:
 property Microsoft::Office::Interop::Excel::XlDisplayUnit DisplayUnit { Microsoft::Office::Interop::Excel::XlDisplayUnit get(); void set(Microsoft::Office::Interop::Excel::XlDisplayUnit value); };
public Microsoft.Office.Interop.Excel.XlDisplayUnit DisplayUnit { get; set; }
Public Property DisplayUnit As XlDisplayUnit

Property Value

Remarks

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.

XlDisplayUnit can be one of these XlDisplayUnit constants:

xlHundredMillions

xlHundredThousands

xlMillions

xlTenThousands

xlThousands

xlHundreds

xlMillionMillions

xlTenMillions

xlThousandMillions

The unit label can also be one of the following constants:

xlCustom

xlNone

Applies to