Why different colors of bars?

[Amit]

Hello,

When I switch from sheet1 to chart1 page. I see different color of bars
in my graph. How can I set them all to blue or any other color but
unique? I need to do this using VBA coding.

Thanks,
AK

 

[Cindy M.]

Hi Amit,

When I switch from sheet1 to chart1 page. I see different color of bars
in my graph. How can I set them all to blue or any other color but
unique? I need to do this using VBA coding.

Try asking this in the excel.programming newsgroup.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail