Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart Formats
Does anyone know a way to freeze pivot chart FORMAT, while allowing data
updates? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart - Remove Variables | Charts and Charting in Excel | |||
Customizing a Pivot Chart | Charts and Charting in Excel | |||
How do I show the Grand Total on a Pivot Chart? | Charts and Charting in Excel | |||
copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
pivot chart format | Charts and Charting in Excel |