GrapeCity.Documents.Excel.SparkType

SparkType Enum

Specifies the type of sparkline.

Use this enum with ISparklineGroups to create line, column, or win/loss sparklines for a range. The ColumnStacked100 value represents a win/loss sparkline.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SparkType

Public Enum SparkType

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {1, 3, 2},
    {4, 2, 5},
    {3, 6, 4}
};
worksheet.Range["D1:D3"].SparklineGroups.Add(SparkType.Line, "A1:C3");

Fields

Name	Description
Column	Specifies a column chart sparkline.
ColumnStacked100	Specifies a win/loss sparkline. This type displays each data point as an equally sized column above or below the axis to indicate positive or negative values.
Line	Specifies a line chart sparkline.

Name

Description

Column

Specifies a column chart sparkline.

ColumnStacked100

Specifies a win/loss sparkline.

This type displays each data point as an equally sized column above or below the axis to indicate positive or negative values.

Line

Specifies a line chart sparkline.