Free Support Forum - aspose.com

Update chart datasource

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

Hi,

Thanks for considering Aspose.

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

Thanks for being patient.

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"];