How do i stop the colors changing on my pivot chart when i refresh the pivot table?
K kev from uk Mar 2, 2005 #1 How do i stop the colors changing on my pivot chart when i refresh the pivot table?
D Debra Dalgleish Mar 2, 2005 #2 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
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