Pivot charts are well known for resetting their formatting when the pivot
table is adjusted. It's a known issue, and Microsoft recommends recording a
macro when you reformat the chart, so you can rerun the macro as required.
Alternatively you could create a custom chart type and reapply it as needed:

http://peltiertech.com/Excel/ChartsH...stomTypes.html

or make a regular chart from a pivot chart:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

Also, I'd dispense with the fancy formatting, but I'm a voice in the
marketing wilderness.

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


"PatK" wrote in message
...
I have a funky problem..not sure why. Let's say I create a bar chart, and
format each of the bars with a nice set of gradient colors, that varies
based
upon the data series source. In other words, several different color
bars,
on standard color per series.

Now, if I happen to "touch" the data behind the chart in any way (in my
case, a pivot table), the data element I change seems to go back to a
"default" color scheme. I still have other bars that look like I want,
but
say, one month bar, for one data series, now looks different than the
other
11 for the year. I want to to to "paint" the format from the good bars,
back
onto the mucked up bar.

Any way you can think of to make this work?