Default Colours in a Bar Graph

[Guest]

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

 

[Bernard Liengme]

Two possible solutions:
a) make a custom default chart:
http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html
or
b) use Tools|Options; open Colors tab and change colours for Chart Fill &
Chart Line
best wishes

 

[Guest]

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