Chart.Walls Property

Gets a Walls object that represents the walls 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 Walls As Walls

Walls Walls { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Walls
A Walls object that represents the walls of the 3-D chart.

Examples

The following code example creates a 3-D Chart and then uses the Walls property to set the weight and color of the walls of the chart.

Private Sub SetWallsBorder()
    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.Walls.Border.Color = _
            ColorTranslator.ToOle(Color.Green)
    Chart1.Walls.Border.Weight = Excel.XlBorderWeight.xlThick
End Sub

private void SetWallsBorder()
{
    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.Walls.Border.Color =
        ColorTranslator.ToOle(Color.Green);
    chart1.Walls.Border.Weight = Excel.XlBorderWeight.xlThick;
}

.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