Documents for Excel, Java Edition Documentation
Features / Chart / Customize Chart Objects / Floor
In This Topic
    Floor
    In This Topic

    In GcExcel Java, floor represents the floor of a three-dimensional chart. Using floor as the charting object, you can format the area of a 3-D chart quickly and efficiently.

    Users can set the line and fill format of the floor along with its thickness.

    To set the floor format in a chart, refer to the following example code.

    Java
    Copy Code
    IShape shape = worksheet.getShapes().addChart(ChartType.Column3D, 250, 20, 350, 250);
    worksheet.getRange("A1:D6").setValue(
            new Object[][] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 }, { "Item2", -51, -36, 27 },
                    { "Item3", 52, -85, -30 }, { "Item4", 22, 65, 65 }, { "Item5", 23, 69, 69 } });
    shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true);
    
    shape.getChart().getFloor().setThickness(5);
    shape.getChart().getFloor().getFormat().getFill().getColor().setRGB(Color.GetYellow());
    shape.getChart().getFloor().getFormat().getLine().getColor().setRGB(Color.GetRed());