Thank you Bernard. This is working fine. I learnt something new from a guru
today. Thanks for your help

"Bernard Liengme" wrote:

Two possible solutions:
a) make a custom default chart:
http://peltiertech.com/Excel/ChartsH...stomTypes.html
or
b) use Tools|Options; open Colors tab and change colours for Chart Fill &
Chart Line
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"balajimylar" wrote in message
...
Whenever I select a Chart by default the colour of the 2 series are Blue &
Brown. Is there any way by which I can change these colours to Red &
Green
by default so that whenever I select data to create a chart the first
series
should appear in Red bars and the next series should appear as green bars.
Thanks for the reply in answering this query