管理Excel图表的数据标签
Contents
[
Hide
]
数据标签是图表的重要组成部分。
我们可以轻松地了解每个系列的值、百分比等。
数据标签选项
Aspose.Cells 还允许在运行时管理图表的数据标签,使用DataLabels对象,简单地移动,更新和格式化图表的数据标签。
||
管理图表的数据标签
使用 Aspose.Cells DataLabels 可简单地管理图表的数据标签。
下面的代码片段演示了如何管理数据标签:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Instantiating a Workbook object | |
Workbook workbook = new Workbook(); | |
// Adding a new worksheet to the Workbook object | |
int sheetIndex = workbook.Worksheets.Add(); | |
// Obtaining the reference of the newly added worksheet by passing its sheet index | |
Worksheet worksheet = workbook.Worksheets[sheetIndex]; | |
// Adding sample values to cells | |
worksheet.Cells["A1"].PutValue(50); | |
worksheet.Cells["A2"].PutValue(100); | |
worksheet.Cells["A3"].PutValue(150); | |
worksheet.Cells["B1"].PutValue(60); | |
worksheet.Cells["B2"].PutValue(32); | |
worksheet.Cells["B3"].PutValue(50); | |
// Adding a chart to the worksheet | |
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Column, 5, 0, 15, 5); | |
// Accessing the instance of the newly added chart | |
Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex]; | |
// Adding SeriesCollection (chart data source) to the chart ranging from "A1" cell to "B3" | |
chart.NSeries.Add("A1:B3", true); | |
//Show value labels | |
chart.NSeries[0].DataLabels.ShowValue = true; | |
//Show series name labels | |
chart.NSeries[1].DataLabels.ShowSeriesName = true; | |
//Move labels to center | |
chart.NSeries[1].DataLabels.Position = LabelPositionType.Center; | |
// Save the file | |
workbook.Save("chart_datalabels.xlsx"); |