Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Chart Problem when Refreshing
Hello-
I am having the issue that I would like to customize a Pivot Chart to a more meaningful chart than the default one, but whenever I refresh the Pivot Table the Pivot Chart goes back to its original default settings. Is it possible to have a customized Pivot Chart that remains formatted after refreshing the pivot table? Thank you. Filo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Chart Problem when Refreshing
Hi Filo,
I'm not sure if you can prevent this happening when refreshing, but you could record a macro whilst you are formatting the Pivot Chart, so that you have that process in code, and then in the Worksheet Module for the Pivot Table you can use the Worksheet_PivotTableUpdate Sub to capture when the Table is refreshed and use it to call the macro you recorded. You will have to add some code to check that it is a refresh operation, otherwise the macro will run every time you amend anything in the Pivot Table. Alternatively you could always run the macro manually when you refresh the Pivot Table. Sean. -- (please remember to click yes if replies you receive are helpful to you) "Filo" wrote: Hello- I am having the issue that I would like to customize a Pivot Chart to a more meaningful chart than the default one, but whenever I refresh the Pivot Table the Pivot Chart goes back to its original default settings. Is it possible to have a customized Pivot Chart that remains formatted after refreshing the pivot table? Thank you. Filo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing Pivot Chart | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
How do I keep my own formatting for a pivot-chart on refreshing | New Users to Excel | |||
Pivot table is not refreshing problem | Excel Programming | |||
VC Problem refreshing pivot table | Excel Discussion (Misc queries) |