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
I have an excel workbook that has numerous tables and each table has an excel vertical bar chart linked to it. is it possible to have a macro change the color of 1 of the vertical bars based on a specific name, say "brand a" where the remaining bars stay the same color (this would apply for all charts in the workbook)
thanks !
rob k

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic