// Create a new workbook Workbook workbook = new Workbook(); // Prepare data IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.setName("Data"); worksheet.getRange("A1:C13").setValue(new Object[][]{ {null, "Blue Series", "Orange Series"}, {"Jan", 0, 59.1883603948205}, {"Feb", 44.6420211591501, 52.2280901938606}, {"Mar", 45.2174930051225, 49.8093056416248}, {"Apr", 62, 37.3065749226828}, {"May", 53, 34.4312192530766}, {"Jun", 31.8933622049831, 69.7834561753736}, {"Jul", 41.7930895085093, 63.9418103906982}, {"Aug", 73, 57.4049534494926}, {"Sep", 49.8773891668518, 33}, {"Oct", 50, 74}, {"Nov", 54.7658428630216, 22.9587876597096}, {"Dec", 32, 54}, }); // Create a chart sheet and add an area chart IWorksheet chartSheet = workbook.getWorksheets().add(SheetType.Chart); chartSheet.activate(); chartSheet.setName("Chart"); IShape shape = chartSheet.getShapes().addChart(ChartType.Area, 0, 0, 360, 230); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C13"), RowCol.Columns); shape.getChart().getChartTitle().setText("Area Chart"); // Set the chart sheet to fit selection chartSheet.getSheetView().setFitSelection(true); // Save to an excel file workbook.save("FitSelection.xlsx");