XlSparklineRowCol Enumeration
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlSparklineRowCol
'Usage
Dim instance As XlSparklineRowCol
public enum XlSparklineRowCol
Members
| Member name | Description | |
|---|---|---|
| xlSparklineNonSquare | The sparkline is not bound to data in a square-shaped range. | |
| xlSparklineRowsSquare | Plot the data by rows. | |
| xlSparklineColumnsSquare | 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.