GrapeCity.Documents.Excel.Drawing.IAxis.MaximumScale

MaximumScale Property

MaximumScale

Gets or sets the maximum value on the value axis.

Use MaximumScaleIsAuto to determine whether this value is calculated automatically by Excel or set explicitly.

Declaration

double MaximumScale { get; set; }

Property MaximumScale As Double

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.MaximumScale = 20;
double maximumScale = axis.MaximumScale;