ChartSheet.PlotBy Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assemblies:: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.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 the way columns or rows are used as data series on the ChartSheet.

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

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

member this.PlotBy : Microsoft.Office.Interop.Excel.XlRowCol with get, set

Public Property PlotBy As XlRowCol

Property Value

XlRowCol

One of the following XlRowCol constants: xlColumns or xlRows.

Examples

The following code example uses the PlotBy property to set the current Microsoft.Office.Tools.Excel.ChartSheet to display data by rows.

private void PlotByRows()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DBarClustered; 
    this.PlotBy = Excel.XlRowCol.xlRows;
}

Private Sub PlotByRows()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DBarClustered
    Me.PlotBy = Excel.XlRowCol.xlRows
End Sub

Remarks

For PivotChart reports, this property is read-only and always returns xlColumns.

Applies to