How to edit the DataLabels of a chart?

Aspose.Cells Product Family
1

Hi!

In Excel is possible to edit the DataLabels value because is just a text.

In Aspose.Cells I can’t find any way to acess the collection of DataLabels value.
It only allows me to select if I want to show the Value or Percentage.

Question: is it possible to edit the DataLabel for each Value of a series in a Chart?..

Thanks in advance


2

Hi,

Thanks for considering Aspose.

Question: is it possible to edit the DataLabel for each Value of a series in a Chart?..

Well, yes in the newer version: Aspose.Cells for .NET (Latest Version)

I write the following code which changes the third datalabel point value in the chart of a template excel file (attached), since the chart has only one data series:

Workbook workbook = new Workbook();

workbook.Open(“d:\test\pie_charttest.xls”);

Worksheet sheet = workbook.Worksheets[1];

Chart chart = sheet.Charts[0];

DataLabels datalabels = chart.NSeries[0].Points[2].DataLabels;

datalabels.Text = "Unided Kingdom, 30K ";

workbook.Save(“d:\test\pie_charttest1.xls”);

Thank you.

3

That’s exactly what we wanted!

Thanks for the (very) quick response!