ChartArea Object

Description

Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesn't 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.

Using the ChartArea Object

Use the ChartArea property to return the ChartArea object. 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, AutoScaleFont property, Border property, Creator property, Fill 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.