GrapeCity.Documents.Excel.Drawing.IAxis.MaximumScaleIsAuto

MaximumScaleIsAuto Property

MaximumScaleIsAuto

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

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

Declaration

bool MaximumScaleIsAuto { get; set; }

Property MaximumScaleIsAuto 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);
bool maximumScaleIsAuto = axis.MaximumScaleIsAuto;