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)

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.

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 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;
}
Return to top
Show: