This is a known problem with pivot charts. There's some information in
the following MSKB article, which suggests recording a macro as you
apply the formatting:
Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904
dblack wrote:
After establishing all desired fonts, text alignments, and data series
colors/patterns within a pivot chart, I cannot preserve the settings. As I
change a selection in a page field button on the chart, the data series
revert back to default color settings.
Any autoformat options I can toggle on/off?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html