I have a workbook with 2 worksheets. I would like the first worksheet to display the data, and the second worksheet to display a chart using data from worksheet 1.
The online documentation recommends
Worksheet worksheet = workbook.Worksheets;
int chartIndex = worksheet.Charts.Add(ChartType.Bar, 10, 0,30 , 10);
Chart chart = worksheet.Charts[chartIndex];
But the chart.NSeries object defaults to the same worksheet the chart is on. Is it possible to point the chart.NSeries to a different worksheet? Or do I have to copy the values of worksheet 1 to worksheet 2?
Thanks in advance