XlSparklineRowCol Enum

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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 XlSparklineRowCol

public enum XlSparklineRowCol

Public Enum XlSparklineRowCol

Inheritance: Enum
XlSparklineRowCol

Fields

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.

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