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
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.
That’s exactly what we wanted!
Thanks for the (very) quick response!