Pivot charts - Losing formatting
I am using pivot charts to make lots of mini charts from a large set of data.
Every time I add to the data and refresh the charts they lose their formatting and I have to go through and reformat everything! I have to change the colours and the font size, its driving me crazy. Is there a way to stop it reformatting everything and making it keep my changes? -- Thanks, Rob E. |
Pivot charts - Losing formatting
Hi,
This is a know problem. Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/default...;EN-US;Q215904 Cheers Andy Rob E wrote: I am using pivot charts to make lots of mini charts from a large set of data. Every time I add to the data and refresh the charts they lose their formatting and I have to go through and reformat everything! I have to change the colours and the font size, its driving me crazy. Is there a way to stop it reformatting everything and making it keep my changes? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 12:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com