ExcelSparklineGroupsCollectionAdd Method |
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.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic ExcelSparklineGroup Add(
ExcelSparklineType type,
ExcelRange dataRange,
ExcelRange locationRange
)
Public Function Add (
type As ExcelSparklineType,
dataRange As ExcelRange,
locationRange As ExcelRange
) As ExcelSparklineGroup
Parameters
- type ExcelSparklineType
- The type of the sparklines.
- dataRange ExcelRange
- The range with the values. It can be in another worksheet.
- locationRange ExcelRange
- The cells where the sparklines are drawn, a single row or a single column of
the worksheet that owns this collection. The number of cells must be the number of rows or columns of the data range.
Return Value
ExcelSparklineGroupThe new sparkline group.
See Also