Tools menu Options Color tab. The bottom two rows are the default chart
colors.

Note that if the pivot chart's layout reverts to a default layout, changing
the colors may not help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"J.W. Aldridge" wrote in message
oups.com...

"..........change the defaults in the color palette, which changes the
defaults for everything."


I may use the macro method but curious about changing the color pallete
method. I am adding two columns per month so I would have to re-record
the macro each time if I use the maco method.

How would I go about changing the defaults in the color palete?


Thanx