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
To prevent colour loss, you can also set your preferred colours in
Tools>Options, Color tab, by modifying the Chart Fills and Chart Lines
colors.
