Class ChartArea (Excel VBA)

The class ChartArea represents the chart area of a chart.

The main procedures of class ChartArea are Copy and Select

Methods

These are the main methods of the ChartArea class

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.

Parent returns the parent object for the specified object. Read-only.

RoundedCorners true if the chart area of the chart has rounded corners.

Worksheets("Sheet1").ChartObjects(1).Chart.ChartArea.RoundedCorners = True

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.