Click or drag to resize

ExcelSparklineGroupsCollection Methods

The ExcelSparklineGroupsCollection type exposes the following members.

Methods
 NameDescription
Public methodAdd Adds a group of sparklines. The location range is a single row or a single column of cells and gets one sparkline in each cell: when the location is a column, each row of the data range is drawn in the cell of the same row; when the location is a row, each column of the data range is drawn in the cell of the same column. For example the data range "B2:M5" and the location range "N2:N5" draw the twelve months of each row in column N. Sparklines are available only in the Excel 2007+ (.xlsx) format.
Public methodClear Removes all the sparkline groups of the worksheet.
Public methodGetEnumerator Gets the collection enumerator
Public methodRemoveAt Removes the sparkline group at the specified index.
Top
See Also