Partager via


ChartSheetBase.PlotArea Property

Gets a PlotArea object that represents the plot area of a 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 ReadOnly Property PlotArea As PlotArea
public PlotArea PlotArea { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.PlotArea
A PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheetBase.

Examples

The following code example uses the PlotArea property of the current Microsoft.Office.Tools.Excel.ChartSheetBase to change the color of the border around the plot area of the chart.

Private Sub SetPlotAreaBorderColor()
    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.PlotArea.Border.Color = _
            ColorTranslator.ToOle(Color.Green)
End Sub
private void SetPlotAreaBorderColor()
{
    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.PlotArea.Border.Color =
        ColorTranslator.ToOle(Color.Green);
}

.NET Framework Security

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace