// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart("Area chart", 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}, }); // Get chart by name IShape areaChart = worksheet.getShapes().get("Area chart"); areaChart.getChart().getSeriesCollection().add(worksheet.getRange("A1:C13"), RowCol.Columns); areaChart.getChart().getChartTitle().setText("Area Chart"); // Save to an excel file workbook.save("CreateChartWithCustomName.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart("Area chart", 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)) // Get chart by name val areaChart = worksheet.shapes["Area chart"] areaChart.chart.seriesCollection.add(worksheet.getRange("A1:C13"), RowCol.Columns) areaChart.chart.chartTitle.text = "Area Chart" // Save to an excel file workbook.save("CreateChartWithCustomName.xlsx")