Creating Chart in a different worksheet than datas

Hi,

It’s possible to create Chart in a different worksheet than his datas ?

Best regards.

Sure you can.

//add data within the same worksheet

chart.NSeries.Add("C2:C29", true);

//add data from another worksheet

chart.NSeries.Add("Sheet2!C2:C29", true);