GrapeCity.Documents.Excel.ISparklineGroups.Group

Group Method

Group(IRange)

Groups the selected sparklines.

Use this method to combine existing sparklines in the associated range into a sparkline group so they share the same group settings.

Declaration

void Group(IRange Location = null)

Sub Group(Optional Location As IRange = Nothing)

Parameters

Type	Name	Description
IRange	Location	The range that contains the sparklines to group, or null to use the associated range.

Examples

IRange range = worksheet.Range["A1:A3"];
worksheet.Range["B1:B3"].Value = new object[] {1, 3, 2};
range.SparklineGroups.Add(SparkType.Line, "B1:B3");
worksheet.Range["D1:D3"].Value = new object[] {2, 4, 1};
worksheet.Range["E1:E3"].SparklineGroups.Add(SparkType.Line, "D1:D3");
worksheet.Range["A1:E3"].SparklineGroups.Group();