GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMaxScaleValue

CustomMaxScaleValue Property

CustomMaxScaleValue

Gets or sets the custom maximum value for the vertical axis of a sparkline.

Use this property to set or retrieve the manual maximum axis value after the maximum scale type has been set to SparkScaleCustom.

Declaration

double CustomMaxScaleValue { get; set; }

Property CustomMaxScaleValue As Double

Examples

worksheet.Range["A1:A4"].Value = new object[,] {{2}, {5}, {3}, {7}};
ISparklineGroup group = worksheet.Range["B1"].SparklineGroups.Add(SparkType.Line, "A1:A4");
ISparkVerticalAxis verticalAxis = group.Axes.Vertical;
verticalAxis.MaxScaleType = SparkScale.SparkScaleCustom;
verticalAxis.CustomMaxScaleValue = 10;
double maxScaleValue = verticalAxis.CustomMaxScaleValue;