XlSparklineRowCol enumeration (Excel)
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
| Name | Value | Description |
|---|---|---|
| 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.
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.