ChartArea Object (Excel)
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

ChartArea Object (Excel)

Represents the chart area of a chart.

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 PlotArea Object.

Use the ChartArea property to return the ChartArea object.

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
© 2015 Microsoft