Chart Coloring
I need a way to select the color for the bars in a bar chart befor the
creation of the chart. I know how to select the colors once the chart is created, is there a way to automatically change the chart colors? |
Chart Coloring
You can change the default colours Excel uses for chart fills and lines
respectively, in Tools/Options/Color. The colours from left to right are the ones Excel picks for your data series in order of selection. Select the colour to be changed and click Modify... The rest is evident I gather. In the same pane you can also import colours from another workbook (e.g., your company house style, defined in other sheets). HTH, GL, Henk "a" wrote: I need a way to select the color for the bars in a bar chart befor the creation of the chart. I know how to select the colors once the chart is created, is there a way to automatically change the chart colors? |
All times are GMT +1. The time now is 11:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com