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

Microsoft suggests recording a macro one time when you fix the pivot chart
formatting, so you can rerun the macro next time.

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


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



is there any way to stop the default from changing the colors back
after I've adjusted them?