XlSparklineRowCol Enumeration
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

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)

public enum XlSparklineRowCol

Member nameDescription
xlSparklineNonSquareThe sparkline is not bound to data in a square-shaped range.
xlSparklineRowsSquarePlot the data by rows.
xlSparklineColumnsSquarePlot the data by columns.

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.

© 2016 Microsoft