ChartArea Members
Include Protected Members
Include Inherited Members
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.
The ChartArea type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | 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). |
|
AutoScaleFont | True if the text in the object changes font size when the object size changes. The default value is True. |
|
Border | Returns a Border object that represents the border of the object. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. |
|
Fill | Returns a FillFormat object for a specified shape or a ChartFillFormat object for a specified chart that contains fill formatting properties for the shape or chart. |
|
Font | Returns a Font object that represents the font of the specified object. |
|
Format | Returns the ChartFormat object. Read-only. |
|
Height | The height, in points, of the object. |
|
Interior | Returns an Interior object that represents the interior of the specified object. |
|
Left | The distance, in points, from the left edge of the object to the left edge of the chart area. |
|
Name | Returns the name of the object. |
|
Parent | Returns the parent object for the specified object. |
|
RoundedCorners | True if the embedded chart has rounded corners. Read/write Boolean. |
|
Shadow | True if the font is a shadow font or if the object has a shadow. |
|
Top | 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 | The width, in points, of the object. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
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. |
Top