Loss of formatting is a known problem with pivot charts. There's
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


rook wrote:
How do you maintain the format for Pivot Table charts? I know how to
maintian the format for the table but I don't know how to keep it for the
charts. When I run the Pivot table it changes the format that I've setup for
the chart.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html