• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Refresh Pivot Chart with VBA

S

Surekha

Member
I have one pivot chart with fixed formatting. Whenever I changed the data source of my pivot at run time with VBA, It automatically change the whole setting of Pivot chart with its data source.
Is there any way to refresh Pivot charts with new data source as we do with pivot tables.

Thanks in advance.
 
Pivot charts are based on pivot tables.... Change the data source of the pivot table and it changes for the chart. Refresh the table, refreshes the chart.
Sounds like it should be the same deal with VBA.
It is not clear to me what the issue could be, or what the question is. You did say
Whenever I changed the data source of my pivot at run time with VBA, It automatically change the whole setting of Pivot chart with its data source."
Click to expand...
So you are already doing what you are asking? Clearly I'm missing something here... Can you clarify please.
 
You must log in or register to reply here.
Back
Top