You can group, clear, and switch rows and columns with sparklines.
Grouping merges sparklines into a new group and removes them from the old groups. If the selected sparklines belong to different groups with different types, the new group will have the type of the last selected group. The new group will also have the empty cell, style, and axis settings of the last selected group.
Ungrouping selected sparkline groups separates them into different groups that contain only one sparkline. The data and location range of the original sparkline are used in the new groups. The settings of the original group are also used in the new groups.
You can clear a sparkline in code with the ClearSparklines method in the Sheetview class.
You can switch the range of data used in the sparkline from row to column or column to row. Use the SwitchRowColumn method in the ExcelSparklineGroup class in code. The range of data should have the same number of rows and columns. Use the AddSquareSparkline method in the SheetView class to add a sparkline that can be switched.
Return to Using Sparklines.
Using Code
- Use the GroupSparkline method to group sparkline cells.
- Use the UnGroupSparkline method to ungroup sparkline cells.
Example
This example shows how to use the GroupSparkline method or the UnGroupSparkline method.
| C# |  Copy Code |
|---|---|
fpSpread1.Sheets[0].GroupSparkline(new FarPoint.Web.Spread.Model.CellRange[] { new FarPoint.Web.Spread.Model.CellRange(5, 0, 3, 1) }); // fpSpread1.Sheets[0].UnGroupSparkline(new FarPoint.Web.Spread.Model.CellRange[] { new FarPoint.Web.Spread.Model.CellRange(5, 0, 3, 1) }); |
|
| VB | Copy Code |
|---|---|
FpSpread1.Sheets(0).GroupSparkline(New FarPoint.Web.Spread.Model.CellRange() {New FarPoint.Web.Spread.Model.CellRange(5, 0, 3, 1)}) 'FpSpread1.Sheets(0).UnGroupSparkline(New FarPoint.Web.Spread.Model.CellRange() {New FarPoint.Web.Spread.Model.CellRange(5, 0, 3, 1)}) |
|
Using the Spread Designer
- Select the sparkline cells.
- Select Group or Ungroup in the Group section of the toolbar to group or ungroup sparklines.
- Select Clear if you wish to remove any sparklines.
- Use the Edit Data option to edit the data or switch the range of data used in the sparkline.
- Select Apply and Exit from the File menu to save your changes and close the designer.