XlSparklineRowCol enumeration

Office 2013 and later

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)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

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.

Show: