Share via


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).

See Also

Reference

SparklineGroup Interface

SparklineGroup Members

Microsoft.Office.Interop.Excel Namespace