Class ChartArea (Excel VBA)

The class ChartArea represents the chart area of a chart.

Class Chart gives access to class ChartArea.

Member in collection

Item

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.

Properties

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.