GrapeCity.Documents.Excel.ISparklineGroup.PlotBy

PlotBy Property

PlotBy

Gets or sets how to plot the sparkline when the data on which it is based is in a square-shaped range.

The returned SparklineRowCol value indicates whether the source data is plotted by rows, by columns, or is not treated as a square-shaped range.

Declaration

SparklineRowCol PlotBy { get; set; }

Property PlotBy As SparklineRowCol

Examples

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