You received two replies. It appears you are using the MS Communities Web
News interface which can make things very difficult and unreliable.

http://groups.google.co.uk/group/mic...el.programming

Regards,
Peter T

"Jay" wrote in message
...
I posted this a few days ago and no one has responded. Does anyone know
how
to manipulate the colors of a chart in Excel 2007???

I have the following code that was written in Excel 2003. Every
time I run it in Excel 2007 it crashes. I can't find anything about
changing
the colors of a series in an Excel 2007 chart. Also, when I try to record
a
macro to change the chart colors to gain insight, nothing gets written to
the
macro regarding the color change. Help!

Sheets("Chart1").SeriesCollection(1).Interior.Colo rIndex = 5