Excel.PlotArea(object).md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PlotArea object (Excel)	vbaxl10.chm617072	vbaxl10.chm617072	Excel.PlotArea	85c42124-268c-8b0e-ba5d-c2f6fbf53e79	03/30/2019	medium

PlotArea object (Excel)

Represents the plot area of a chart.

Remarks

This is the area where your chart data is plotted. The plot area on a 2D chart contains the data markers, gridlines, data labels, trendlines, and optional chart items placed in the chart area. The plot area on a 3D chart contains all the above items plus the walls, floor, axes, axis titles, and tick-mark labels in the chart.

The plot area is surrounded by the chart area. The chart area on a 2D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3D chart contains the chart title and the legend. For information about formatting the chart area, see the ChartArea object.

Example

Use the PlotArea property to return a PlotArea object. The following example activates the chart sheet named "Chart1," places a dashed border around the chart area of the active chart, and places a dotted border around the plot area.

Charts("Chart1").Activate 
With ActiveChart 
 .ChartArea.Border.LineStyle = xlDash 
 .PlotArea.Border.LineStyle = xlDot 
End With

Methods

• ClearFormats
• Select

Properties

• Application
• Creator
• Format
• Height
• InsideHeight
• InsideLeft
• InsideTop
• InsideWidth
• Left
• Name
• Parent
• Position
• Top
• Width

See also

• Excel Object Model Reference

[!includeSupport and feedback]