ChartSheet.SideWall Property

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assemblies:

Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Gets an object that represents the side wall of a 3-D chart.

public:
 property Microsoft::Office::Interop::Excel::Walls ^ SideWall { Microsoft::Office::Interop::Excel::Walls ^ get(); };

public Microsoft.Office.Interop.Excel.Walls SideWall { get; }

member this.SideWall : Microsoft.Office.Interop.Excel.Walls

Public ReadOnly Property SideWall As Walls

Property Value

Walls

A Walls object that represents the side wall of a 3-D chart.

Examples

The following code example specifies the colors of the walls and floor of an existing 3-D chart sheet and sets the chart style to style 4. To run this code example, the workbook must contain a chart sheet called Chart1 of a 3-D type.

private void SetChartSheetDesign()
{
    // Add a new chart and populate source data
    Microsoft.Office.Tools.Excel.ChartSheet myChartSheet =
        Globals.Chart1.Base;

    myChartSheet.BackWall.Format.Fill.ForeColor.RGB =
        System.Drawing.Color.LightGray.ToArgb();
    myChartSheet.SideWall.Format.Fill.ForeColor.RGB =
        System.Drawing.Color.LightGray.ToArgb();
    myChartSheet.Floor.Format.Fill.ForeColor.RGB =
        System.Drawing.Color.Gray.ToArgb();

    myChartSheet.ChartStyle = 4;
}

Private Sub SetChartSheetDesign()
    ' Add a new chart and populate source data
    Dim myChartSheet As Microsoft.Office.Tools.Excel.ChartSheet = _
        Globals.Chart1.Base

    myChartSheet.BackWall.Format.Fill.ForeColor.RGB = _
        System.Drawing.Color.LightGray.ToArgb()
    myChartSheet.SideWall.Format.Fill.ForeColor.RGB = _
        System.Drawing.Color.LightGray.ToArgb()
    myChartSheet.Floor.Format.Fill.ForeColor.RGB = _
        System.Drawing.Color.Gray.ToArgb()

    myChartSheet.ChartStyle = 4
End Sub

Remarks

Use the SideWall property to format the side wall of a 3-D chart.