Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Gets or sets the way columns or rows are used as data series on the Microsoft.Office.Tools.Excel.ChartSheetBase.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Property PlotBy As XlRowCol
public XlRowCol PlotBy { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlRowCol
One of the following XlRowCol constants: xlColumns or xlRows.
Remarks
For PivotChart reports, this property is read-only and always returns xlColumns.
Examples
The following code example uses the PlotBy property to set the current Microsoft.Office.Tools.Excel.ChartSheetBase to display data by rows.
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
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;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.