Click or drag to resize

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.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public ExcelSparklineGroup Add(
	ExcelSparklineType type,
	ExcelRange dataRange,
	ExcelRange locationRange
)

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

ExcelSparklineGroup
The new sparkline group.
See Also