GrapeCity.Documents.Excel.ISparkVerticalAxis.MaxScaleType

MaxScaleType Property

MaxScaleType

Gets or sets how the maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

Use this property to determine whether the sparkline group's vertical axis maximum is calculated per sparkline, shared across the group, or defined by a custom value through CustomMaxScaleValue.

Declaration

SparkScale MaxScaleType { get; set; }

Property MaxScaleType As SparkScale

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.SparkScaleGroup;
SparkScale maxScaleType = verticalAxis.MaxScaleType;