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?