SparklineGroup.PlotBy Property
Definition
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 XlSparklineRowColProperty 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).