Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904

kev from uk wrote:
How do i stop the colors changing on my pivot chart when i refresh the pivot
table?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html