+ Reply to Thread
Results 1 to 4 of 4

Pivot Tables that updates multiple pie charts at once

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Urbana, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Pivot Tables that updates multiple pie charts at once

    Greetings,

    I have four pie charts created with four pivot tables. Is there a way to so that when I filter data in one pivot table all of the pie charts become updated base on that criteria rather than just updating the one pie chart affiliated with the pivot table? Im guessing VBA is the only way to go with this since its for excel 2007. Is anyone able to provide a code that could execute this function? I have posted this in another forum as well but I have yet to get a reply. Heres the link:
    http://www.excelguru.ca/forums/showt...charts-at-once

    Thank you in advance

    I have also attached a sample workbook for those looking for a visual idea of what I am talking about.
    DummyWorkbook.xlsx

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Pivot Tables that updates multiple pie charts at once

    I'm not sure it's available in 2007 but you might look up slicers....but I believe you need one common item in all 4 PT....I have one that I use to change PT and the common item is the Customer Name....I use the slicer to change that and it updates all 7 PT and associated charts....HTH.....
    Last edited by judgeh59; 08-08-2013 at 11:27 AM. Reason: OOPS
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    06-03-2013
    Location
    Urbana, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Re: Pivot Tables that updates multiple pie charts at once

    I have confirmed that slicers are not available in excel 2007. VBA seems to be the only way of going about this. Is there a code that you could provide to execute this situation? Otherwise I may have to upgrade to 2010.
    Last edited by Paragoomba; 08-08-2013 at 11:55 AM.

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Pivot Tables that updates multiple pie charts at once

    I don't have any VBA code to run....I was in 2010 when I started writing something but I got rid of it because slicers were the answer....sorry.....you can search in Google/Yahoo/Dogpile for code to do this....it still may require having a common field in each PT though....sorry I couldn't help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting multiple Pivot Tables and Charts in Excel 2007
    By deltaquattro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2011, 04:05 AM
  2. Change order of query updates in pivot tables
    By ste1000 in forum Excel General
    Replies: 0
    Last Post: 10-16-2006, 07:25 AM
  3. Daily updates of pivot tables
    By jack ireland in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2005, 05:56 AM
  4. Replies: 2
    Last Post: 08-24-2005, 09:05 AM
  5. Replies: 0
    Last Post: 01-19-2005, 06:34 AM

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