Class ChartArea (Excel VBA)
The class ChartArea represents the chart area of a chart.
Class Chart gives access to class ChartArea.
Member in collection
To use a ChartArea class variable it first needs to be instantiated, for example
Dim caa as ChartArea Set caa = ActiveChart.ChartArea
ChartArea class variables can be set using the Chart.ChartArea procedure.
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.
Format returns the ChartFormat object.
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.
RoundedCorners true if the chart area of the chart has rounded corners.
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.
ChartFormat - Provides access to the Office Art formatting for chart elements.