| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Default Colours in a Bar Graph
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Default Colours in a Bar Graph
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Default Colours in a Bar Graph
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Colours | Excel Discussion (Misc queries) | |||
| Modify the default graph colors | Charts and Charting in Excel | |||
| Chart Default Line colours | Excel Discussion (Misc queries) | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
| Change the default chart colours | Charts and Charting in Excel | |||
Linear Mode
