ChartArea Object [Excel 2003 VBA Language Reference]

Multiple objects

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

Parent Objects | Chart Object

Child Objects | Border Object | ChartFillFormat Object | Font Object | Interior Object