Document Solutions for Excel, Java Edition | Document Solutions
Features / Chart / Configure Chart / Plot Area
In This Topic
    Plot Area
    In This Topic

    In DsExcel Java, you can use the methods of the IPlotArea interface in order to set up the plot area in a chart as per your preferences.

    Configure plot area format

    You can configure the plot area format via modifying its fill color, line color and other essential attributes using the getPlotArea method of the IChart interface.

    To configure plot area format for a chart inserted in your worksheet, refer to the following example code.

    Java
    Copy Code
    IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 250, 20, 360, 230);
    worksheet.getRange("A1:D6").setValue(new Object[][] { { null, "S1", "S2", "S3" }, { "Item1", 10, 25, 25 },
            { "Item2", -51, 36, 27 }, { "Item3", 52, 50, -30 }, { "Item4", 22, 65, 30 }, { "Item5", 23, 40, 69 } });
    shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true);
    
    IPlotArea plotarea = shape.getChart().getPlotArea();
            
    // Format.
    plotarea.getFormat().getFill().getColor().setRGB(Color.GetLightGray());
    plotarea.getFormat().getLine().getColor().setRGB(Color.GetGray());