Class Walls (Excel VBA)
The class Walls represents the walls of a 3D 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.
To use a Walls class variable it first needs to be instantiated, for example
Dim wlls as Walls Set wlls = ActiveChart.BackWall
Clears the formatting of the object.
Returns the ChartFormat object.
Dim cftFormatted As ChartFormat Set cftFormatted = ActiveChart.BackWall.Format
Returns a String value that represents the name of the object.
Dim strName As String strName = ActiveChart.BackWall.Name
Pastes a picture from the Clipboard on the walls of the specified chart.
This method can be used on column, bar, line, or radar charts.
Returns or sets a value that represents the way pictures are displayed on the walls and faces of a 3D chart.xlStack - Picture is sized to repeat a maximum of 15 times in the longest stacked bar, xlStackScale - Picture is sized to a specified number of units and repeated the length of the bar, xlStretch - Picture is stretched the full length of the stacked bar.
This property can be set to one of the following XlChartPictureType constants: xlStack or xlStretch.
ActiveChart.BackWall.PictureType = xlStack
Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored). Read/write Long.xlStack - Picture is sized to repeat a maximum of 15 times in the longest stacked bar, xlStackScale - Picture is sized to a specified number of units and repeated the length of the bar, xlStretch - Picture is stretched the full length of the stacked bar.
Selects the object.
Returns or sets a Long specifying the thickness of the wall.
Use this property to set the thickness of the wall. The default thickness is 0.