ChartArea Object [Excel 2003 VBA Language Reference]
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
Parent Objects | Chart Object