GrapeCity.Documents.Excel.SparkScale

SparkScale Enum

Specifies how the minimum or maximum value of a sparkline vertical axis is scaled relative to other sparklines in the group.

Use this enum with the vertical axis settings of a sparkline group to control whether all sparklines share the same scale, each sparkline uses its own calculated scale, or a custom axis value is applied.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SparkScale

Public Enum SparkScale

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {2, 4, 6},
    {3, 9, 1},
    {5, 7, 8}
};
ISparklineGroup group = worksheet.Range["D1:D3"].SparklineGroups.Add(SparkType.Line, "A1:C3");
group.Axes.Vertical.MinScaleType = SparkScale.SparkScaleCustom;
group.Axes.Vertical.CustomMinScaleValue = 0;
group.Axes.Vertical.MaxScaleType = SparkScale.SparkScaleCustom;
group.Axes.Vertical.CustomMaxScaleValue = 10;

Fields

Name	Description
SparkScaleCustom	Specifies that the minimum or maximum value for the vertical axis of the sparkline has a user-defined value.
SparkScaleGroup	Specifies that the minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value.
SparkScaleSingle	Specifies that the minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value.