ChartArea Members (Excel)

Represents the chart area of a chart.

Methods

Name	Description
Clear	Clears the entire object.
ClearContents	Clears the data from a chart but leaves the formatting.
ClearFormats	Clears the formatting of the object.
Copy	Copies the object to the Clipboard.
Select	Selects the object.

Properties

Name	Description
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Format	Returns the ChartFormat object. Read-only.
Height	Returns or sets a Double value that represents the height, in points, of the object.
Left	Returns or sets a Double value that represents the distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
Name	Returns a String value that represents the name of the object.
Parent	Returns the parent object for the specified object. Read-only.
RoundedCorners	True if the chart area of the chart has rounded corners. Read/write Boolean.
Shadow	Returns or sets a Boolean value that determines if the object has a shadow.
Top	Returns a Double value that represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
Width	Returns or sets a Double value that represents the width, in points, of the object.