GrapeCity.Documents.Excel.SparklineRowCol

SparklineRowCol Enum

Specifies how sparklines are plotted when the source data is in a square-shaped range.

Used with PlotBy and PlotBy to control whether sparkline data is plotted by rows or columns.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SparklineRowCol

Public Enum SparklineRowCol

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {1, 2, 3},
    {4, 5, 6},
    {7, 8, 9}
};
ISparklineGroup group = worksheet.Range["D1:D3"].SparklineGroups.Add(SparkType.Line, "A1:C3");
group.PlotBy = SparklineRowCol.RowsSquare;
SparklineRowCol plotBy = group.PlotBy;

Fields

Name	Description
ColumnsSquare	Specifies to plot the data by columns.
NonSquare	Specifies that the sparkline is not bound to data in a square-shaped range.
RowsSquare	Specifies to plot the data by rows.