PlotArea Members

Use the PlotArea object to control the appearance of the region behind series on a chart. Use the Chart object’s PlotArea property to get a reference to this collection. The PlotArea object has the following members . Key members (shown in bold) are covered in the following reference section:

Application

Border

ClearFormats

Creator

Fill

Height

InsideHeight

InsideLeft

InsideTop

InsideWidth

Interior

Left

Name

Parent

Select

Top

Width

 

Plot area property settings correspond to the settings on the Format Plot Area dialog box (Figure 17-7). To see the dialog, right-click the plot area and select Format Plot Area.

Use this dialog to control the appearance of the region behind series

Figure 17-7. Use this dialog to control the appearance of the region behind series

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial