XlSparklineRowCol Enum


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

public enum class XlSparklineRowCol
public enum XlSparklineRowCol
Public Enum XlSparklineRowCol


xlSparklineColumnsSquare 2

Plot the data by columns.

xlSparklineNonSquare 0

The sparkline is not bound to data in a square-shaped range.

xlSparklineRowsSquare 1

Plot the data by rows.


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.

Applies to