An option would be to set the color palette appropriately (Tools |
Options... | Color tab) and then for the chart set the 'vary color by
points' option. To access the last one double-click the plotted series
and in the resulting dialog box select the Options tab.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I want to create a bar chart with the following spec.

the first bar with green color

the 2nd bar with blue color

the 3rd and beyond with red color