SparklineGroup.PlotBy Property

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.

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

public:
 property Microsoft::Office::Interop::Excel::XlSparklineRowCol PlotBy { Microsoft::Office::Interop::Excel::XlSparklineRowCol get(); void set(Microsoft::Office::Interop::Excel::XlSparklineRowCol value); };

public Microsoft.Office.Interop.Excel.XlSparklineRowCol PlotBy { get; set; }

Public Property PlotBy As XlSparklineRowCol

Property Value

XlSparklineRowCol

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

Remarks

Read/write.

This property can only be set if the data on which the sparkline is based is in a square-shaped range, for example if the data is in the range A1:B2.

The default value for sp data in a square-shaped range is to plot the data by rows (xlSparklineRowsSquare).

Applies to