ChartSheet.ChartArea Property (2007 System)
Gets a ChartArea that represents the complete chart area for the 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 ChartArea As ChartArea
'Usage
Dim instance As ChartSheet
Dim value As ChartArea
value = instance.ChartArea
[BrowsableAttribute(false)]
public ChartArea ChartArea { get; }
[BrowsableAttribute(false)]
public:
property ChartArea^ ChartArea {
ChartArea^ get ();
}
public function get ChartArea () : ChartArea
Property Value
Type: ChartArea
A ChartArea that represents the complete chart area for the Microsoft.Office.Tools.Excel.ChartSheet.
Examples
The following code example uses the ChartArea property of the current Microsoft.Office.Tools.Excel.ChartSheet to modify the weight and color of the chart area border.
Private Sub ModifyChartBorder()
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.ChartArea.Border.Color = _
ColorTranslator.ToOle(Color.Green)
Me.ChartArea.Border.Weight = Excel.XlBorderWeight.xlThick
End Sub
private void ModifyChartBorder()
{
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.ChartArea.Border.Color =
ColorTranslator.ToOle(Color.Green);
this.ChartArea.Border.Weight = Excel.XlBorderWeight.xlThick;
}
.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.