Pivot Chart Problem when Refreshing

[Filo]

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

 

[SeanC UK]

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.