Class Floor (Excel VBA)

The class Floor represents the floor of a 3D chart. To use a Floor class variable it first needs to be instantiated, for example

Dim flr as Floor
Set flr = ActiveChart.Floor

ClearFormats

Clears the formatting of the object.

ActiveChart.Floor.ClearFormats

Format

Returns the ChartFormat object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveChart.Floor.Format

Name

Returns a String value that represents the name of the object.

Dim strName As String
strName = ActiveChart.Floor.Name

Paste

Pastes a picture from the Clipboard on the floor of the specified chart.

This method can be used on column, bar, line, or radar charts.

ActiveChart.Floor.Paste

PictureType

Returns or sets a value that represents the way pictures are displayed on the walls and faces of a 3D chart. Possible return values are 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.Floor.PictureType = xlStack

Select

Selects the object.

ActiveChart.Floor.Select

Thickness

Returns or sets a Long, specifying the thickness of the floor.

Use this property to set the thickness of the floor. The default thickness is zero (0).

ActiveChart.Floor.Thickness =