ChartSheet.BackWall Property
Gets an object that represents the back wall of a 3-D chart.
Namespace: Microsoft.Office.Tools.Excel
Assemblies: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property BackWall As Walls
Walls BackWall { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Walls
A Microsoft.Office.Interop.Excel.Walls object that represents the back wall of a 3-D chart.
Remarks
Use the BackWall property to format the back 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 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
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;
}
.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.