ChartArea Object

Description

Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend. It does not include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.

Accessors

The ChartArea property returns the chart area for the specified chart. The following example sets the pattern for the chart area in embedded chart one on the worksheet named "Sheet1."


Worksheets("sheet1").ChartObjects(1).Chart. _
    ChartArea.Interior.Pattern = xlLightDown

Properties

Application Property, Border Property, Creator Property, Font Property, Height Property, Interior Property, Left Property, Name Property, Parent Property, Shadow Property, Top Property, Width Property.

Methods

Clear Method, ClearContents Method, ClearFormats Method, Copy Method, Select Method.