xlSparklineRowCol

Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.

SparklineColumnsSquarePlot the data by columns (2)
SparklineNonSquareThe sparkline is not bound to data in a square-shaped range (0)
SparklineRowsSquarePlot the data by rows (1)

SparklineColumnsSquare
Plot the data by columns (2)
SparklineNonSquare
The sparkline is not bound to data in a square-shaped range (0)
SparklineRowsSquare
Plot the data by rows (1)

REMARKS
* Added in 2010.
* The XlSparklineRowCol enumeration is used by the PlotBy property of the SparklineGroup object to determine how to plot chart in a sparkline when data on which it based is in a square-shaped range, such as A1:B2.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top