SparklineGroup.PlotBy Property
Gets or sets how to plot the sparkline when the data on which it is based is in a square-shaped range.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property PlotBy As XlSparklineRowCol
Get
Set
'Usage
Dim instance As SparklineGroup
Dim value As XlSparklineRowCol
value = instance.PlotBy
instance.PlotBy = value
XlSparklineRowCol PlotBy { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.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).