ChartSheetBase.ChartArea Property

Gets a ChartArea that represents the complete chart area for the 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 ChartArea As ChartArea
    Get

public ChartArea ChartArea { get; }

Property Value

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

Examples

The following code example uses the ChartArea property of the current Microsoft.Office.Tools.Excel.ChartSheetBase 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.

See Also

Reference

ChartSheetBase Class

Microsoft.Office.Tools.Excel Namespace