EXCEL Series Line Colors
in [Matlab]
|
From: james bejon on 21 Jul 2010 16:39 I don't have Excel 07 here. But I guess you've tried setting the SeriesCollection.Item(i).Interior.ColorIndex property? Does this just affect the markers or something?
From: Mike on 22 Jul 2010 11:16 >Andy Naw...not looking for trendlines~ >james c.SeriesCollection.Item(#).Interior gives me ??? No appropriate method,...etc :(
From: Andy on 22 Jul 2010 11:42 Try something like the following: ActiveChart.ChartGroups(1).SeriesLines(1).Border.Color = 1; or: ActiveChart.ChartGroups(1).SeriesLines.Border.Color = 1; or: ActiveChart.ChartGroups(1).SeriesLines.Border.ColorIndex = 1;
From: Mike on 22 Jul 2010 12:49 >Andy tried those earlier~ didn't work either :(
From: Andy on 22 Jul 2010 13:10
"Mike " <mike87y(a)gmail.com> wrote in message <i29sq0$ke$1(a)fred.mathworks.com>... > >Andy > tried those earlier~ didn't work either :( Did you try variations, such as ChartGroups.Item(1) instead of ChartGroups(1)? Can you tell CSSM what didn't work (that is, show us the error messages)? Also, I can only do so much reading the Excel developer's reference and suggesting things that sound relevant. I don't have Excel 2007. So you'll need to go through the developer's reference yourself and use trial and error. If you find a solution, you should post it back here. And if you try several more things and still don't find a solution, you should post all of your attempts here along with error messages or undesirable output. |