ChartSheet.ChartArea Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assemblies:
Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

public:
 property Microsoft::Office::Interop::Excel::ChartArea ^ ChartArea { Microsoft::Office::Interop::Excel::ChartArea ^ get(); };
public Microsoft.Office.Interop.Excel.ChartArea ChartArea { get; }
member this.ChartArea : Microsoft.Office.Interop.Excel.ChartArea
Public ReadOnly Property ChartArea As ChartArea

Property Value

ChartArea

A ChartArea that represents the complete chart area for the 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 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;
}

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

Applies to