D Debra Dalgleish Oct 9, 2007 #2 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.
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.
