GrapeCity.Documents.Excel.Drawing.IAxis.MinimumScaleIsAuto

MinimumScaleIsAuto Property

MinimumScaleIsAuto

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

When this property is true, the minimum scale is determined by Excel. When it is false, the minimum scale is set explicitly.

Declaration

bool MinimumScaleIsAuto { get; set; }

Property MinimumScaleIsAuto As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 12},
    {"Feb", 18},
    {"Mar", 15}
};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 360, 220).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
IAxis axis = chart.Axes.Item(AxisType.Value, AxisGroup.Primary);
axis.MinimumScaleIsAuto = false;
bool minimumScaleIsAuto = axis.MinimumScaleIsAuto;