Chart.ChartArea Property

Gets a ChartArea object that represents the complete chart area for the chart.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property ChartArea As ChartArea

ChartArea ChartArea { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.ChartArea
A ChartArea object that represents the complete chart area for the chart.

Examples

The following code example creates a Chart and then uses the ChartArea property to modify the weight and color of the chart area border.

Private Sub UseChartArea()
    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.xlColumnClustered

    Chart1.ChartArea.Border.Color = _
            ColorTranslator.ToOle(Color.Green)
    Chart1.ChartArea.Border.Weight = Excel.XlBorderWeight.xlThick
End Sub

private void UseChartArea()
{
    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.xlColumnClustered;

    chart1.ChartArea.Border.Color = ColorTranslator.ToOle(Color.Green);
    chart1.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.

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace