XlSparklineRowCol XlSparklineRowCol XlSparklineRowCol Enum

Definition

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
Inheritance
XlSparklineRowColXlSparklineRowColXlSparklineRowCol

Fields

xlSparklineColumnsSquare xlSparklineColumnsSquare xlSparklineColumnsSquare 2

Plot the data by columns.

xlSparklineNonSquare xlSparklineNonSquare xlSparklineNonSquare 0

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

xlSparklineRowsSquare xlSparklineRowsSquare xlSparklineRowsSquare 1

Plot the data by rows.

Remarks

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