Document Solutions for Excel, Java Edition | Document Solutions
Features / Chart / Customize Chart Objects / Walls
In This Topic
    Walls
    In This Topic

    A wall refers to an area or a plane that is present behind, below or beside a chart.

    Using DsExcel Java, you can configure a chart as per your custom preferences via defining the thickness, fill color, line color and format of the back wall as well as the side wall, using the methods of the IWall interface and the IChart interface. 

    In order to configure the walls of the chart inserted in a worksheet, refer to the following example code.

    Java
    Copy Code 
    // Config back wall and side wall's format together.
IShape shape1 = worksheet.getShapes().addChart(ChartType.Column3D, 10, 10, 250, 250);
shape1.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true);
shape1.getChart().getSideWall().setThickness(20);
shape1.getChart().getSideWall().getFormat().getFill().getColor().setRGB(Color.GetRed());
shape1.getChart().getSideWall().getFormat().getLine().getColor().setRGB(Color.GetBlue());
        
// Config back wall's format individually.
IShape shape2 = worksheet.getShapes().addChart(ChartType.Column3D, 300, 10, 250, 250);
shape2.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true);
shape2.getChart().getBackWall().setThickness(20);
shape2.getChart().getBackWall().getFormat().getFill().getColor().setRGB(Color.GetRed());
shape2.getChart().getBackWall().getFormat().getLine().getColor().setRGB(Color.GetBlue());