Excel 2010 - change default chart color order

I really like that excel 2010 gives you standard templates that look nice, but I'm not happy with the colors that I get when using these standard templates.

For example, I like that I can go to Chart Tools -> Design and choose the chart style in row 3, column 2 -- however, I do not like the colors that the program defaults to.

There must be a way to change the order of default colors -- please show me how.

Thanks!

I don't see an answer. Anyone out there?

I have the same question. Does anyone know the answer?

As far as I'm aware, the charts use the colours in the same order as they appear in the colours box when, for example, you go to the text colour or fill colour boxes.

It starts with the fifth colour along that box (the one it knows as "Accent 1"), and then the sixth, seventh, eighth, etc (which it knows as Accent 2, Accent 3, etc).

To change the order of the colours on the graph, you need to change the order of the colours for the whole file.

Page Layout -> Colors -> Create New Theme Colors...

Here you can change Accent 1-6 (just rearranging the ones that are there, or adding completely new colours).

Once you've done that, use that colour scheme and it'll do the graph in those colours.


Of course it'll *also* change the respective colours elsewhere in the document, so setting your blue colour to pink for a pretty graph will also mean that your tables/text/etc elsewhere in that same blue colour will also go pink ;-)