Floor Property

Microsoft Office Web Components Object Model

Floor Property

       

Returns a ChSurface object that represents the floor of a three-dimensional chart. Use the properties and methods of the returned ChSurface object to format the floor of the specified chart.

expression.Floor

expression   Required. An expression that returns a ChPlotArea object.

Example

This example converts the first chart in Chartspace1 to a 3-D Column chart and then formats the back wall, side wall, and floor of the chart.

Sub FormatWallsFloor()

    Dim cht3DColumn
    Dim chConstants

    Set chConstants = Chartspace1.Constants

    ' Set a variable to the first chart in Chartspace1.
    Set cht3DColumn = ChartSpace1.Charts(0)

    ' Change the chart to a 3D Column chart.
    cht3DColumn.Type = chConstants.chChartTypeColumnClustered3D

    ' Format the back wall of the chart.
    cht3DColumn.BackWall.Interior.SetSolid "Yellow"
    cht3DColumn.BackWall.Thickness = 5

    ' Format the side wall of the chart.
    cht3DColumn.SideWall.Interior.SetSolid "Yellow"
    cht3DColumn.SideWall.Thickness = 5

    ' Format the floor of the chart.
    cht3DColumn.Floor.Interior.SetSolid "Blue"
    cht3DColumn.Floor.Thickness = 5

End Sub