Edit

Share via

Chart.ChartArea property (Excel)

  • Article

Returns a ChartArea object that represents the complete chart area for the chart. Read-only.

Syntax

expression.ChartArea

expression A variable that represents a Chart object.

Example

This example sets the chart area interior color of Chart1 to red, and sets the border color to blue.

With Charts("Chart1").ChartArea 
 .Interior.ColorIndex = 3 
 .Border.ColorIndex = 5 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.