Rich Text Custom Data Label of Chart Point

Rich Text Custom Data Label of Chart Point

The following code accesses the first chart point of the first series, sets its text and then sets the font of the first 10 characters by settings it’s color to red and boldness to true.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(RichTextCustomData.class);
// Create a workbook from source Excel file
Workbook workbook = new Workbook(dataDir + "source.xlsx");
// Access first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
// Access the first chart inside the sheet
Chart chart = worksheet.getCharts().get(0);
// Access the data label of first series first point
DataLabels dlbls = chart.getNSeries().get(0).getPoints().get(0).getDataLabels();
// Set data label text
dlbls.setText("Rich Text Label");
// Set the font setting of the first 10 characters
FontSetting fntSetting = dlbls.characters(0, 10);
fntSetting.getFont().setColor(Color.getRed());
fntSetting.getFont().setBold(true);
// Save the workbook
workbook.save("output.xlsx");
  • Set the Shape Type of Data Labels of Chart