Chart.Floor Property

Gets a Floor object that represents the floor of the 3-D chart.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property Floor As Floor

Floor Floor { get; }

Property Value

Type: Floor
A Floor object that represents the floor of the 3-D chart.

Examples

The following code example creates a 3-D Chart and then uses the Floor property to change the color of the chart floor to green.

Private Sub SetElevationAndFloor()
    Me.Range("A1", "A5").Value2 = 22
    Me.Range("B1", "B5").Value2 = 55

    Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
        Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")

    Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
    Chart1.ChartType = Excel.XlChartType.xl3DColumn

    Chart1.Floor.Interior.Color = _
            ColorTranslator.ToOle(Color.Green)
    Chart1.Elevation = 75
End Sub

private void SetElevationAndFloor()
{
    this.Range["A1", "A5"].Value2 = 22;
    this.Range["B1", "B5"].Value2 = 55;

    Microsoft.Office.Tools.Excel.Chart chart1 =
        this.Controls.AddChart(this.Range["D2", "H12"], 
        "chart1");

    chart1.SetSourceData(this.Range["A1", "B5"], 
        Excel.XlRowCol.xlColumns);
    chart1.ChartType = Excel.XlChartType.xl3DColumn;

    chart1.Floor.Interior.Color =
        ColorTranslator.ToOle(Color.Green);
    chart1.Elevation = 75;
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

Chart Interface

Microsoft.Office.Tools.Excel Namespace