ChartSheet.PlotArea Property (2007 System)
Gets a PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property PlotArea As PlotArea
'Usage
Dim instance As ChartSheet
Dim value As PlotArea
value = instance.PlotArea
[BrowsableAttribute(false)]
public PlotArea PlotArea { get; }
[BrowsableAttribute(false)]
public:
property PlotArea^ PlotArea {
PlotArea^ get ();
}
public function get PlotArea () : PlotArea
Property Value
Type: PlotArea
A PlotArea object that represents the plot area of a Microsoft.Office.Tools.Excel.ChartSheet.
Examples
The following code example uses the PlotArea property of the current Microsoft.Office.Tools.Excel.ChartSheet 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
- 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.