[]
A wall is the plane behind or beside a 3-D chart. Use this interface to access the wall's IChartFormat and to control its thickness for walls returned by IChart.getBackWall() or IChart.getSideWall().
worksheet.getRange("A1:B3").setValue(new Object[][] {
{"Name", "Value"},
{"A", 1},
{"B", 2}
});
IShape shape = worksheet.getShapes().addChart(ChartType.Column3D, 10, 10, 250, 250);
shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B3"), RowCol.Columns, true, true);
IWall wall = shape.getChart().getSideWall();
wall.setThickness(20);
wall.getFormat().getFill().getColor().setRGB(Color.GetRed());
intvoidsetThickness(int value) The returned IChart is the 3-D chart that owns this wall, such as the back wall or side wall.
IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
IChart parentChart = chart.getBackWall().getParent();
IChart that contains this wall.The returned IChartFormat object provides access to the wall's fill and line formatting for a 3-D chart.
IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
IChartFormat format = chart.getBackWall().getFormat();
format.getFill().getColor().setRGB(Color.GetRed());
IChartFormat object that represents the wall formatting.Use this method to read the current thickness setting of a wall in a 3-D chart, such as the back wall or side wall.
IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
chart.getBackWall().setThickness(5);
int thickness = chart.getBackWall().getThickness();
Use this method to set the thickness of a wall in a 3-D chart, such as the back wall or side wall.
IChart chart = worksheet.getShapes().addChart(ChartType.ColumnClustered3D, 20, 20, 360, 220).getChart();
chart.getBackWall().setThickness(5);
value - The thickness of the wall.