G Guest Feb 1, 2006 #1 How do I retain pivot chart formats that I have made (esp. column colours) after refreshing the data on the source pivot table?
How do I retain pivot chart formats that I have made (esp. column colours) after refreshing the data on the source pivot table?
A Andy Pope Feb 1, 2006 #2 Hi, Loss of chart formatting wwith regards to pivot charts is a know problem, which requires VBA to re apply recorded formatting. XL2000: Changing a PivotChart Removes Series Formatting (Q215904) <http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904 > Cheers Andy
Hi, Loss of chart formatting wwith regards to pivot charts is a know problem, which requires VBA to re apply recorded formatting. XL2000: Changing a PivotChart Removes Series Formatting (Q215904) <http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904 > Cheers Andy
