Sdílet prostřednictvím

XlSparklineRowCol Enumeration

  • Článek

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

Version Information

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.

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.