Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the way columns or rows are used as data series on the chart.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property PlotBy As XlRowCol
XlRowCol PlotBy { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlRowCol
One of the following XlRowCol values: xlColumns or xlRows.
Examples
The following code example creates a Chart with data plotted by columns, and then prompts the user to plot data by rows with the PlotBy property.
Private Sub ChangePlotToRows()
Me.Range("A1", "A5").Value2 = 22
Me.Range("B1", "B5").Value2 = 55
Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")
Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
Chart1.ChartType = Excel.XlChartType.xl3DColumn
If DialogResult.Yes = MessageBox.Show("The chart is " & _
"currently plotted by columns. Change to plot by rows?", _
"Example", MessageBoxButtons.YesNo) Then
Chart1.PlotBy = Excel.XlRowCol.xlRows
End If
End Sub
private void ChangePlotToRows()
{
this.Range["A1", "A5"].Value2 = 22;
this.Range["B1", "B5"].Value2 = 55;
Microsoft.Office.Tools.Excel.Chart chart1 =
this.Controls.AddChart(this.Range["D2", "H12"],
"chart1");
chart1.SetSourceData(this.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
chart1.ChartType = Excel.XlChartType.xl3DColumn;
if (DialogResult.Yes ==
MessageBox.Show("The chart is currently plotted by columns." +
" Change to plot by rows?", "Example",
MessageBoxButtons.YesNo))
{
chart1.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.