Update chart datasource

Aspose.Cells Product Family
1

hi,

I have created a chart in an excel file, the name of the chart is 'Graphic 1', and we use Aspose.Cells to fill a sheet of the workbook. But i would like tu update the datasource of the chart to take care of all data apped.

I saw that i can (add or update ?) data to the chart with this line of code :
Chart chart=worksheet.Charts[chartIndex];
chart.NSeries.Add("A1:B4",true);


Can you give us a sample of code to do use the name of the chart (Graphic 1).

Regards

2

Hi,

Thanks for considering Aspose.

We will implement this feature (Accessing designer charts by its name) soon.

Thanks for being patient.

3

Hi,

If the chart is not in 2007 xlsx template file, we have support this feature.

Please try the following codes :Chart chart=worksheet.Charts["Graphic 1"];