XlSparklineRowCol Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
public enum class XlSparklineRowColpublic enum XlSparklineRowColPublic Enum XlSparklineRowCol- Inheritance
-
XlSparklineRowCol
Fields
| Name | Value | Description |
|---|---|---|
| xlSparklineNonSquare | 0 | The sparkline is not bound to data in a square-shaped range. |
| xlSparklineRowsSquare | 1 | Plot the data by rows. |
| xlSparklineColumnsSquare | 2 | Plot the data by columns. |
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.