I use graphs quite extensively in Excel and often need to change colors of
alot of bars in a bar graph. Using the format painter will make this go alot
quicker

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Have you experimented using the Fill Color tool - icon has a paint can at an
angle- to recolour bars?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"farah" wrote in message
...
I use graphs quite extensively in Excel and often need to change colors of
alot of bars in a bar graph. Using the format painter will make this go
alot
quicker

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting