Manage DataLabels of Excel Charts

DataLabels are an important part of a chart. We can easily know the value, percentage, etc. of each series

DataLabels Options

Aspose.Cells also allows to manage chart’s datalabels at runtime，with DataLabels object, it’s simple to move, update and format datalabels of the chart.

| todo:image_alt_text |

Manage the DataLabels of Chart

It’s simple to manage datalabels of the chart with Aspose.Cells DataLabels.

The following code snippet demonstrates how to manage DataLabels:

	// 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");

view raw chart_datalabels.cs hosted with ❤ by GitHub

Advance topics

Read and Manipulate Excel 2016 Charts Shapes in Charts