GrapeCity.Documents.Excel.Drawing.IAxis.BaseUnitIsAuto

BaseUnitIsAuto Property

BaseUnitIsAuto

Gets or sets whether the base unit is selected automatically for the specified category axis.

If this property is true, Microsoft Excel chooses an appropriate base unit for the category axis automatically. The default value is true.

Declaration

bool BaseUnitIsAuto { get; set; }

Property BaseUnitIsAuto As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Date", "Sales"},
    {45292d, 12},
    {45323d, 18},
    {45352d, 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
IAxis axis = chart.Axes.Item(AxisType.Category, AxisGroup.Primary);
axis.BaseUnitIsAuto = false;
bool autoBaseUnit = axis.BaseUnitIsAuto;