图表点的富文本自定义数据标签

您可以使用Aspose.Cells创建图表点的富文本自定义数据标签。Aspose.Cells提供了 DataLabels.characters() 方法，返回 FontSetting 对象，该对象可用于设置文本的字体属性，如颜色、粗体等。

以下代码访问第一系列的第一个图表点，设置其文本，然后将前10个字符的字体颜色设置为红色，并将粗体设置为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");

相关文章