+ Reply to Thread
Results 1 to 3 of 3

How can you refresh a Pivot Chart ?

  1. #1
    Registered User
    Join Date
    07-24-2007
    Location
    London, England
    MS-Off Ver
    Office 365 ProPlus
    Posts
    80

    How can you refresh a Pivot Chart ?

    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.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: How can you refresh a Pivot Chart ?

    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.

  3. #3
    Registered User
    Join Date
    07-24-2007
    Location
    London, England
    MS-Off Ver
    Office 365 ProPlus
    Posts
    80

    Re: How can you refresh a Pivot Chart ?

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1