ExcelBanter - Pivot Chart Formats

On Tue, 30 May 2006, in microsoft.public.excel.charting,
John Francis said:

Does anyone know a way to freeze pivot chart FORMAT, while allowing data
updates?

It's annoying the way the pivot chart destroys all your carefully chosen
formatting every time it refreshes.

Perhaps, just before you refresh, you could copy the formats to an empty
sheet, then copy them back again onto the pivot table after the refresh?
Perhaps the clever folk who know VBA could even arrange for a macro to
do it automatically?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.