GcExcel Java enables users to configure data labels so as to ensure the information depicted in a chart can be interpreted and visualized easily and quickly.
You can insert data labels in a chart using the methods of the ISeries interface.
In order to configure data labels in a chart and set the data label text, refer to the following example code.
| Java |
Copy Code |
|---|---|
IShape shape1 = worksheet.getShapes().addChart(ChartType.ColumnClustered, 200, 20, 300, 300); Object[][] data = 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 } }; worksheet.getRange("A1:D6").setValue(data); // Set Series's all data labels and specific data label's format. shape1.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true); ISeries series1 = shape.getChart().getSeriesCollection().get(0); series1.setHasDataLabels(true); // Set series1's all data label's format. series1.getDataLabels().getFormat().getFill().getColor().setRGB(Color.GetGreen()); series1.getDataLabels().getFormat().getLine().getColor().setRGB(Color.GetRed()); series1.getDataLabels().getFormat().getLine().setWeight(3); // set series1's specific data label's format. series1.getDataLabels().get(2).getFormat().getFill().getColor().setRGB(Color.GetYellow()); series1.getPoints().get(2).getDataLabel().getFormat().getLine().getColor().setRGB(Color.GetBlue()); series1.getPoints().get(2).getDataLabel().getFormat().getLine().setWeight(5); // Customize data label's text. IShape shape2 = worksheet.getShapes().addChart(ChartType.ColumnClustered, 200, 20, 300, 300); shape2.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true); ISeries series2 = shape.getChart().getSeriesCollection().get(0); series2.setHasDataLabels(true); // customize data label's text. series2.getDataLabels().setShowCategoryName(true); series2.getDataLabels().setShowSeriesName(true); series2.getDataLabels().setShowLegendKey(true); | |
You can also configure the text angle for data labels by using the setOrientation method of IDataLabel interface. The text angle can also be exported or imported to JSON.
Refer to the following example code to set text angle for data label.
| Java |
Copy Code |
|---|---|
//create a new workbook Workbook workbook = new Workbook(); // Fetch default worksheet IWorksheet worksheet = workbook.getWorksheets().get(0); //add chart 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); //set series1's all data labels' angle series1.getDataLabels().setOrientation(45); //set series1's specific data label's angle series1.getDataLabels().get(2).setOrientation(-45); //save to an excel file workbook.save("configdatalabelangle.xlsx"); | |