SparklineGroupCollection.Add(CellRange, CellRange, SparklineGroupType) Method
Creates a sparkline group of the specified type and adds it to the collection.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v20.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core
Declaration
Parameters
Name | Type | Description |
---|---|---|
position | CellRange | A CellRange object that specifies the cell range where the sparkline group should be located. |
dataRange | CellRange | A CellRange object that specifies the cell range containing the source data for the group. |
type | SparklineGroupType | A SparklineGroupType enumeration member specifying the type of the group to be created. |
Returns
Type | Description |
---|---|
SparklineGroup | A SparklineGroup object that is the newly created group of sparklines. |
Remarks
The example below demonstrates how to create two groups of sparklines using the Add method of the SparklineGroupCollection collection accessible from the Worksheet.SparklineGroups property.
Worksheet worksheet = workbook.Worksheets["SparklineExamples"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Create a group of line sparklines.
SparklineGroup quarterlyGroup = worksheet.SparklineGroups.Add(worksheet["G4:G6"], worksheet["C4:F4,C5:F5,C6:F6"], SparklineGroupType.Line);
// Add one more sparkline to the existing group.
quarterlyGroup.Sparklines.Add(6, 6, worksheet["C7:F7"]);
// Display a column sparkline in the total cell.
SparklineGroup totalGroup = worksheet.SparklineGroups.Add(worksheet["G8"], worksheet["C8:F8"], SparklineGroupType.Column);