I have a small Pivot Table which has an associated Pivot Chart. I have just added some data to the Pivot Table and refresh it. How can I get the Pivot Chart to update automatically to include the new data I've added ? Kevin.
I have a small Pivot Table which has an associated Pivot Chart. I have just added some data to the Pivot Table and refresh it. How can I get the Pivot Chart to update automatically to include the new data I've added ? Kevin.
In worksheet module, insert the code like you see below. You might need to change the name of the pivot table that you're using
Please Login or Register to view this content.
Thanks. The code does update the Pivot Table, but I have a Pivot Chart (Pie Chart) which I also want to update automatically when the Pivot Table has additional data added. How can you update the Pie Chart without having to create a new one. Thanks Kevin.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks