GrapeCity.Documents.Excel.ISparkVerticalAxis.CustomMinScaleValue

CustomMinScaleValue Property

CustomMinScaleValue

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

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

Declaration

double CustomMinScaleValue { get; set; }

Property CustomMinScaleValue 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.MinScaleType = SparkScale.SparkScaleCustom;
verticalAxis.CustomMinScaleValue = 1;
double minScaleValue = verticalAxis.CustomMinScaleValue;