Pivot Chart Problem when Refreshing

F

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
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top