software

Whenever I select a Chart by default the colour of the 2 series are Blue amp;
Brown. Is there any way by which I can change these colours to Red amp; 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

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

quot;balajimylarquot; gt; wrote in message
...
gt; Whenever I select a Chart by default the colour of the 2 series are Blue amp;
gt; Brown. Is there any way by which I can change these colours to Red amp;
gt; Green
gt; by default so that whenever I select data to create a chart the first
gt; series
gt; should appear in Red bars and the next series should appear as green bars.
gt; Thanks for the reply in answering this query
Thank you Bernard. This is working fine. I learnt something new from a guru
today. Thanks for your help

quot;Bernard Liengmequot; wrote:

gt; Two possible solutions:
gt; a) make a custom default chart:
gt; peltiertech.com/Excel/ChartsH...stomTypes.html
gt; or
gt; b) use Tools|Options; open Colors tab and change colours for Chart Fill amp;
gt; Chart Line
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;balajimylarquot; gt; wrote in message
gt; ...
gt; gt; Whenever I select a Chart by default the colour of the 2 series are Blue amp;
gt; gt; Brown. Is there any way by which I can change these colours to Red amp;
gt; gt; Green
gt; gt; by default so that whenever I select data to create a chart the first
gt; gt; series
gt; gt; should appear in Red bars and the next series should appear as green bars.
gt; gt; Thanks for the reply in answering this query
gt;
gt;
gt;