Walls Object [Excel 2007 Developer Reference]

Switch View :

ScriptFree

Walls Object

Represents the walls of a 3-D chart. This object isn’t a collection. There’s no object that represents a single wall; you must return all the walls as a unit.

Example

Use the Walls property to return the Walls object. The following example sets the pattern on the walls for embedded chart one on Sheet1. If the chart isn’t a 3-D chart, this example will fail.

Visual Basic for Applications
`Worksheets("Sheet1").ChartObjects(1).Chart _ .Walls.Interior.Pattern = xlGray75`