Expand Minimize

XlSparklineRowCol Enumeration (Excel)

Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.

Version Added: Excel 2010

Name

Value

Description

SparklineColumnsSquare

2

Plot the data by columns.

SparklineNonSquare

0

The sparkline is not bound to data in a square-shaped range.

SparklineRowsSquare

1

Plot the data by rows.

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:
© 2014 Microsoft