GrapeCity.Documents.Excel.Drawing.IAxis.MajorUnitIsAuto

MajorUnitIsAuto Property

MajorUnitIsAuto

Gets or sets whether Excel automatically calculates the major unit for the value axis.

This property is true when the major unit is determined automatically by Excel, and false when a custom major unit is used.

Declaration

bool MajorUnitIsAuto { get; set; }

Property MajorUnitIsAuto As Boolean

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", 25}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B3"], RowCol.Columns, true, true);
IAxis axis = chart.Axes.Item(AxisType.Value, AxisGroup.Primary);
axis.MajorUnitIsAuto = true;
bool isAuto = axis.MajorUnitIsAuto;