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?

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?