Rob,

Never done it (Excel VBA is one of my weaker points), but in the Excel VBA help I find this piece of code:
Charts(1).SeriesCollection(1).Interior.Color = RGB(255, 0, 0)
and that looks definitely promising.

Of course, you've got to find the corresponding element in the labels, but I'm sure that's a property of some object inside the graph also.

You might find very useful information with Google. There's a lot of VBA code on available on the Internet. Something like excel vba graph color might be a good starting point.

It might take some time to find out, if you're not experienced in Excel VBA.

Hope this helps.


Kees