Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ChartArea Object

Office 2007
Represents the chart area of a chart.

Remarks

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.

Example

The following example turns off the border for the chart area in embedded chart 1 on the worksheet named "Sheet1."

Visual Basic for Applications
Worksheets("Sheet1").ChartObjects(1).Chart. _
    ChartArea.Format.Line.Visible = False



Community Additions

ADD
Show:
© 2015 Microsoft