// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.Area, 250, 20, 360, 230); 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}, }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C13"), RowCol.Columns); shape.getChart().getChartTitle().setText("Area Chart"); // Save to an excel file workbook.save("AreaChart.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.Area, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:C13").value = arrayOf(arrayOf(null, "Blue Series", "Orange Series"), arrayOf("Jan", 0, 59.1883603948205), arrayOf("Feb", 44.6420211591501, 52.2280901938606), arrayOf("Mar", 45.2174930051225, 49.8093056416248), arrayOf("Apr", 62, 37.3065749226828), arrayOf("May", 53, 34.4312192530766), arrayOf("Jun", 31.8933622049831, 69.7834561753736), arrayOf("Jul", 41.7930895085093, 63.9418103906982), arrayOf("Aug", 73, 57.4049534494926), arrayOf("Sep", 49.8773891668518, 33), arrayOf("Oct", 50, 74), arrayOf("Nov", 54.7658428630216, 22.9587876597096), arrayOf("Dec", 32, 54)) shape.chart.seriesCollection.add(worksheet.getRange("A1:C13"), RowCol.Columns) shape.chart.chartTitle.text = "Area Chart" // Save to an excel file workbook.save("AreaChart.xlsx")