View Single Post
  #2  
Old January 24th, 2008, 07:28 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default change series or line color in excel 2007 vba

This works:

objSeries.Border.Color = RGB(255, 127, 0)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" wrote in message
...
I've done this hundreds of times in 2003, but in 2007 I'm hitting some
snags.
I think it has to do with the chart styles found in excel 2007. I'm
trying
to change the color of a series in my line graph using the following code:

Set ch = Worksheets("Chart").ChartObjects(1)
Set objSeries = ch.Chart.SeriesCollection(1)

objSeries.Format.Line.ForeColor.RGB = RGB(255, 127, 0)

But, this isn't working at all. Nothing is happening to the line. I'm
able
to do other things to the series, such as change the marker style, the
marker
color, the line style, but not the line color.

Any ideas???