PlotArea Members (Excel)

Article
05/23/2016

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.

Methods

Name	Description
ClearFormats	Clears the formatting of the object.
Select	Selects the object.

Properties

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.