Hi guys, for a c# project im working on, i am drawing a Graph with Microsoft.Office.Interop.Excel;
When i draw the graph and set its source, i set its range to the first to columns(a and b) with obviously whatever the last row is(eg: a1:b30).
So the problem is that when i open the excel file, the graph looks like the photo below. i dont want it to look like that. to get it to look right i have to select the graph series 2. so that only series 2 line is plotted.
this is the setting i have to adjust
this is how it looks in the end, and how i want it to look
Btw also would like to know what command i can use to draw the graph to the side of the Worksheet, so that it doesn’t cover some summary info on that worksheet.
thanks!
no comments yet
Be the first to share what you think!
C# devs
null reference exceptions