Edit

Share via


SparklineGroup.PlotBy Property

Definition

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

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