First of all, I've looked at EVERY other post here, about this (I think) and none of them solves it.
I have a graph in excel, where I would like to change the colour of the line. It seems like, everything in the series line settings, is out of reach. If I cannot set the colour, I would like to set the fill to none, so the line is invisible, only showing the markers, which I can manipulate.
However, fill is also in the colour settings.
I have tried recording a macro aswell, but it shows nothing, other than series select.
Other posts here, suggest setting border on the series, but there is no border object to my knowledge.
Does anyone have any tricks that might solve this?
So, over on the MSDN forums, Andrei Smolin managed to solve it for me. It was indeed Series.Border that fixed it.
The big problem was, that Border does not show up, as an object on series. Not even in VBA. It seems to be fixed in Excel 2010, but this is the behaviour i'm experiencing in 2007 SP3.
So, the solution was to simply type:
MSExcel.Series Series1 = (MSExcel.Series)Chart.SeriesCollection(1);
Series1.Border.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.FromArgb(79, 129, 189));
which compiled fine, and worked at runtime.
For reference sake, this is the MSDN thread:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/2816660e-a18e-47f4-b121-02a71cb2c262