//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 250, 20, 360, 230); worksheet.getRange("A1:B5").setValue(new Object[][]{ {null, "S1"}, {"Item1", -20}, {"Item2", 30}, {"Item3", 50}, {"Item3", 40} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B5"), RowCol.Columns, true, true); ISeries series1 = shape.getChart().getSeriesCollection().get(0); series1.setHasDataLabels(true); series1.getDataLabels().setShowSeriesName(true); //set series1's all data label's format. series1.getDataLabels().getFormat().getFill().getColor().setRGB(Color.GetPink()); series1.getDataLabels().getFormat().getLine().getColor().setRGB(Color.GetGreen()); series1.getDataLabels().getFormat().getLine().setWeight(1); //set series1's specific data label's format. series1.getDataLabels().get(2).getFormat().getFill().getColor().setRGB(Color.GetLightGreen()); series1.getPoints().get(2).getDataLabel().getFormat().getLine().getColor().setRGB(Color.GetGray()); series1.getPoints().get(2).getDataLabel().getFormat().getLine().setWeight(2); //save to an excel file workbook.save("ConfigDataLabelFormat.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.ColumnClustered, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:B5").value = arrayOf(arrayOf(null, "S1"), arrayOf("Item1", -20), arrayOf("Item2", 30), arrayOf("Item3", 50), arrayOf("Item3", 40)) shape.chart.seriesCollection.add(worksheet.getRange("A1:B5"), RowCol.Columns, true, true) val series1 = shape.chart.seriesCollection.get(0) series1.hasDataLabels = true series1.dataLabels.showSeriesName = true //set series1's all data label's format. series1.dataLabels.format.fill.color.rgb = Color.GetPink() series1.dataLabels.format.line.color.rgb = Color.GetGreen() series1.dataLabels.format.line.weight = 1.0 //set series1's specific data label's format. series1.dataLabels.get(2).format.fill.color.rgb = Color.GetLightGreen() series1.points.get(2).dataLabel.format.line.color.rgb = Color.GetGray() series1.points.get(2).dataLabel.format.line.weight = 2.0 //save to an excel file workbook.save("ConfigDataLabelFormat.xlsx")