Plot Area | Document Solutions for Excel, Java Edition

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()); plotarea.getFormat().getLine().setWeight(1);

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());
plotarea.getFormat().getLine().setWeight(1);