// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.Pie, 250, 20, 360, 230); worksheet.getRange("A1:B4").setValue(new Object[][]{ {"Blue", 1}, {"Red", 2}, {"Green", 3}, {"Purple", 4}, }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B4"), RowCol.Columns); shape.getChart().getChartTitle().setText("Pie Chart"); shape.getChart().getLegend().setPosition(LegendPosition.Right); // Save to an excel file workbook.save("PieChart.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.Pie, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:B4").value = arrayOf(arrayOf("Blue", 1), arrayOf("Red", 2), arrayOf("Green", 3), arrayOf("Purple", 4)) shape.chart.seriesCollection.add(worksheet.getRange("A1:B4"), RowCol.Columns) shape.chart.chartTitle.text = "Pie Chart" shape.chart.legend.position = LegendPosition.Right // Save to an excel file workbook.save("PieChart.xlsx")