PlotArea Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents the plot area of a chart.

Name

Description

ClearFormats

Clears the formatting of the object.

Select

Selects the object.

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.

InsideHeight

Returns the inside height of the plot area, in points. Read-write Double.

InsideLeft

Returns the distance from the chart edge to the inside left edge of the plot area, in points. Read-write Double.

InsideTop

Returns the distance from the chart edge to the inside top edge of the plot area, in points. Read-write Double.

InsideWidth

Returns the inside width of the plot area, in points. Read-write Double.

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.

Position

Returns or sets the position of the plot area on the chart. Read/write XlChartElementPosition.

Top

Returns or sets 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.

Show: