GrapeCity.Documents.Excel.Drawing.DisplayUnit

DisplayUnit Enum

Specifies the display unit for a value axis.

Use this enum with DisplayUnit to scale the values shown on a chart axis and its display unit label. Use Custom together with the custom display unit settings on the axis when you need a unit value that is not represented by the built-in options.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public enum DisplayUnit

Public Enum DisplayUnit

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 1200},
    {"Feb", 1800}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 220);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B3"], RowCol.Columns, true, true);
IAxis valueAxis = shape.Chart.Axes.Item(AxisType.Value);
valueAxis.DisplayUnit = DisplayUnit.Hundreds;

Fields

Name	Description
Custom	Specifies a custom unit.
HundredMillions	Specifies hundreds of millions.
HundredThousands	Specifies hundreds of thousands.
Hundreds	Specifies hundreds.
MillionMillions	Specifies millions of millions.
Millions	Specifies millions.
None	Specifies no units.
TenMillions	Specifies tens of millions.
TenThousands	Specifies tens of thousands.
ThousandMillions	Specifies thousands of millions.
Thousands	Specifies thousands.