// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.PieOfPie, 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, -85, -30}, {"Item4", 22, 65, 65}, {"Item5", 23, 69, 69} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true); ISeries series1 = shape.getChart().getSeriesCollection().get(0); series1.setHasDataLabels(true); //config secondary section for pie of pie chart shape.getChart().getChartGroups().get(0).setSplitType(ChartSplitType.SplitByCustomSplit); series1.getPoints().get(0).setSecondaryPlot(true); series1.getPoints().get(1).setSecondaryPlot(false); series1.getPoints().get(2).setSecondaryPlot(true); series1.getPoints().get(3).setSecondaryPlot(false); series1.getPoints().get(4).setSecondaryPlot(true); // Save to an excel file workbook.save("ConfigSecondarySection.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.PieOfPie, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:D6").value = arrayOf(arrayOf(null, "S1", "S2", "S3"), arrayOf("Item1", 10, 25, 25), arrayOf("Item2", -51, -36, 27), arrayOf("Item3", 52, -85, -30), arrayOf("Item4", 22, 65, 65), arrayOf("Item5", 23, 69, 69)) shape.chart.seriesCollection.add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true) val series1 = shape.chart.seriesCollection.get(0) series1.hasDataLabels = true //config secondary section for pie of pie chart shape.chart.chartGroups.get(0).splitType = ChartSplitType.SplitByCustomSplit series1.points.get(0).secondaryPlot = true series1.points.get(1).secondaryPlot = false series1.points.get(2).secondaryPlot = true series1.points.get(3).secondaryPlot = false series1.points.get(4).secondaryPlot = true // Save to an excel file workbook.save("ConfigSecondarySection.xlsx")