SparklineGroup.ResetRanges

SparklineGroup.ResetRanges method

Resets the data range and location range of the sparkline group. This method will clear original sparkline items in the group and creates new sparkline items for the new ranges.

public void ResetRanges(string dataRange, bool isVertical, CellArea locationRange)
ParameterTypeDescription
dataRangeStringSpecifies the new data range of the sparkline group.
isVerticalBooleanSpecifies whether to plot the sparklines from the new data range by row or by column.
locationRangeCellAreaSpecifies where the sparklines to be placed.

See Also