Excel.ChartArea(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ChartArea object (Excel)	vbaxl10.chm619072	vbaxl10.chm619072	Excel.ChartArea	883423b5-7689-b164-c0a3-8dab049b5d9e	03/29/2019	medium

ChartArea object (Excel)

Represents the chart area of a chart.

Remarks

The chart area includes everything, including the plot area. However, the plot area has its own fill, so filling the plot area does not fill the chart area.

For information about formatting the plot area, see the PlotArea object.

Use the ChartArea property of the Chart object to return the ChartArea object.

Example

The following example turns off the border for the chart area in embedded chart 1 on the worksheet named Sheet1.

Worksheets("Sheet1").ChartObjects(1).Chart. _ 
 ChartArea.Format.Line.Visible = False

Methods

• Clear
• ClearContents
• ClearFormats
• Copy
• Select

Properties

• Application
• Creator
• Format
• Height
• Left
• Name
• Parent
• RoundedCorners
• Shadow
• Top
• Width

See also

• Excel Object Model Reference

[!includeSupport and feedback]