Chart.BackWall Property (2007 System)
Gets an object that represents the back wall of a 3-D chart.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public ReadOnly Property BackWall As Walls
'Usage
Dim instance As Chart
Dim value As Walls
value = instance.BackWall
public Walls BackWall { get; }
public:
property Walls^ BackWall {
Walls^ get ();
}
public function get BackWall () : Walls
Property Value
Type: Walls
A 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 adds a 3-D clustered column chart to Sheet1 and sets its style to style 4. The example then creates a range of arbitrary data and sets it as the chart source data. Next, the code specifies the colors of the chart walls and floor.
Private Sub SetChartBackWalls()
' Add a new chart and populate source data
Dim myNewChart As Microsoft.Office.Tools.Excel.Chart = _
Globals.Sheet1.Controls.AddChart( _
Globals.Sheet1.Range("D5", "J16"), "myNewChart")
myNewChart.ChartType = Excel.XlChartType.xl3DColumnClustered
' Set chart style
myNewChart.ChartStyle = 4
Globals.Sheet1.Range("A1").Value2 = "Product"
Globals.Sheet1.Range("B1").Value2 = "Units Sold"
Dim i As Integer
For i = 1 To 3
Globals.Sheet1.Range("A" + (i + 1).ToString()).Value2 = _
"Product" + i.ToString()
Globals.Sheet1.Range("B" + (i + 1).ToString()).Value2 = i * 10
Next
Dim data As Excel.Range = Globals.Sheet1.Range("A1", "B4")
myNewChart.SetSourceData(data)
' Set foreground color for 3D chart walls and floor
myNewChart.BackWall.Format.Fill.ForeColor.RGB = _
System.Drawing.Color.LightGray.ToArgb()
myNewChart.SideWall.Format.Fill.ForeColor.RGB = _
System.Drawing.Color.LightGray.ToArgb()
myNewChart.Floor.Format.Fill.ForeColor.RGB = _
System.Drawing.Color.Gray.ToArgb()
End Sub
private void SetChartBackWalls()
{
// Add a new chart and populate source data
Microsoft.Office.Tools.Excel.Chart myNewChart =
Globals.Sheet1.Controls.AddChart(
Globals.Sheet1.Range["D5", "J16"], "myNewChart");
myNewChart.ChartType = Excel.XlChartType.xl3DColumnClustered;
// Set chart style
myNewChart.ChartStyle = 4;
Globals.Sheet1.Range["A1",missing].Value2 = "Product";
Globals.Sheet1.Range["B1",missing].Value2 = "Units Sold";
for (int i=1; i<4; i+)
{
Globals.Sheet1.Range["A" + (i + 1).ToString(),missing].Value2 =
"Product" + i.ToString();
Globals.Sheet1.Range["B" + (i + 1).ToString(),missing].Value2 =
i * 10;
}
Excel.Range data = Globals.Sheet1.Range["A1", "B4"];
myNewChart.SetSourceData(data,missing);
// Set foreground color for 3D chart walls and floor
myNewChart.BackWall.Format.Fill.ForeColor.RGB =
System.Drawing.Color.LightGray.ToArgb();
myNewChart.SideWall.Format.Fill.ForeColor.RGB =
System.Drawing.Color.LightGray.ToArgb();
myNewChart.Floor.Format.Fill.ForeColor.RGB =
System.Drawing.Color.Gray.ToArgb();
}
.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.