
1 Attachment(s)
Excel automation problem
I've used http://csharp.netinformations.com/e...xcelchart.htm
to create a chart, and that works.
I have a little problem, however. I need the data to come from several columns, as the sheet I'm going to make will have one chart with one graph, but use the data of several columns.
So, I took the sheet, and tried to make some modifications, and that worked. Attachment 30703
The formula for the graph is now:
=SERIES(Sheet1!$B$1;(Sheet1!$A$2;Sheet1!$A$3;Sheet1!$A$4;Sheet1!$A$5;Sheet1!$E$2;Sheet1!$E$3;Sheet1!$E$4;Sheet1!$E$5);(Sheet1!$B$2;Sheet1!$B$3;Sheet1!$B$4;Sheet1!$B$5;Sheet1!$F$2;Sheet1!$F$3;Sheet1!$F$4;Sheet1!$F$5);1)
Which means, that I now have added Term58 and corresponding values for Student1.
How to translate the above formula into code? I've tried adding:
Code:
Excel.SeriesCollection seriesCollection = (Excel.SeriesCollection)chartPage.SeriesCollection(misValue);
Excel.Series series1 = seriesCollection.NewSeries();
series1.Formula = "=SERIES(Sheet1!$B$1;(Sheet1!$A$2;Sheet1!$A$3;Sheet1!$A$4;Sheet1!$A$5;Sheet1!$E$2;Sheet1!$E$3;Sheet1!$E$4;Sheet1!$E$5);(Sheet1!$B$2;Sheet1!$B$3;Sheet1!$B$4;Sheet1!$B$5;Sheet1!$F$2;Sheet1!$F$3;Sheet1!$F$4;Sheet1!$F$5);1)";
but that just gives me an exception :(
I hope someone has a solution for this one...thanks in advance.
/Lars VJ