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.
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()); |