Is it possible to link multiple graphs?

As far as I am aware this is not achievable in the way you describe however you can add filters to the data which the charts work off by using Data -> Filter. Any filters you set this way will change all the charts linked to this data.

There may be another way but this is the simplest

Ah I understand, I think this is possible if you had a pivot table for each chart (all off the same default data) and each having their own pivot graphs (which I think you already have).

Make sure each pivot table has a name.

With reference to: https://msdn.microsoft.com/en-us/lib...ice.14%29.aspx and http://www.thespreadsheetguru.com/bl...l-pivot-tables

By using the

Please Login or Register  to view this content.

You can then use this to change the other pivot tables accordingly by using code similar to this:

Please Login or Register  to view this content.

Of course you can be selective of any changes.

I have not tested all the code, but have used similar in the past. Have a read through the site's i've linked - they may give you a better insight into what I am talking about.

Sorry if its not clear or what you need but unfortunately each pivot can only have one graph and using vba is probably the only way to go.

I'm going to have a go at it and post results (good or bad) once I get them and call it done.

Thanks for the help!

The code that should run "on change" should not be within a macro but within the worksheet code.

View the visual basic window and double click on a worksheet, and paste the code in there - this should activate when the pivot changes. You probably will need to do this on every sheet there is a pivot table

I've been trying to add the line of code with the whole "ActiveSheet.PivotTables...("Field1").PivotItems" in a multitude of ways.

I keep getting either error 438 "Object doesn't accept this property or method" or I get "can't assign _Default to PivotField class."

Ah sorry my mistake, each pivot fields' values have to be done individually so you could have something like this:

Please Login or Register  to view this content.

That code or similar should do the trick - and do this for each field in the pivot table and hopefully it will work ?

Hello, been trying it out, and I've been entering an infinite loop somehow.

This is what I've got:

Formula:

Please Login or Register  to view this content.

The first if is because before, as soon as it tried to modify the "TEUS" pivot table, it'd re-launch itself. But even with that, it goes over and over again with the net sales pivot table (don't know why though) so all I get is a popup that launches itself again over and over without anything changing at all.

I went through the 'Step by Step' and once it got to the first line after "For" it went at it once again.

I've tried several modifications to that but nothing's gotten anywhere. Not even the "TEUS" pivot table shows variations of any sort so I'm as lost as before.

Ah, the reason why it is in an endless loop probably is because every change the function is continually called. Perhaps this may be a better solution:

Please Login or Register  to view this content.

This should stop an "infinite loop" - if this doesn't work i'm not sure what to try next. Let me know how it goes.

Did a minor modification to the code

Formula:

Please Login or Register  to view this content.

And though both popups pop, none of the fields in "TEUS" changes, apparently the whole thing running through it without changing the filters. Triple checked the names and field tags to make sure that part's correct, but I don't find anything in that regard.

Ok at least it's out of the loop can you just add these lines to the top of the loop

Please Login or Register  to view this content.

And see what happens as this will ultimately decide any changes.

Ok, ran it through. Got the initial double popup and then the first name on the list followed by "True".

Selected multiple items, selected random items, selected all items, selected the last, selected the first (on the main one meant to change the others).

Then I began doing the same with "TEUS", and though it still showed only the first item on the list, it would only be "True" when said item was selected. Same result each time. Though if I unselected it from "TEUS" it would show "False" though still no more names.

Then I changed the command in the loop to:

Formula:

Please Login or Register  to view this content.

And though it still doesn't move past the first iteration of the loop, if I unselect the first item on the list it'll be mimicked on "TEUS" (so we can't be too far off).

Ok if you remove the three lines that I listed above, does it move past the first iteration?

nope. Still just checks/unchecks the first item so it matches the "master" pivot table

Formula:

Please Login or Register  to view this content.

Ok, so I've applied this and it works so that the FIRST difference between "NetSales" and "TEUS" is fixed. So that if, for example, my filter options are: AA, BB, CC, DD, EE, FF and GG.

If I unselect one in NetSales, say BB, then in TEUS BB will be unselected. But if I unselected BB and DD, then in TEUS only BB would be unselected. Same applies with selecting something that's already selected.

Unfortunately, the filter list for the project is... well, enormous. Just applying the filter in one of the options starting with "V" gets a 3 minute wait time before it's applied to TEUS as well. So (for better or worse), this aspect of the project has been scrapped. I may or may not look for a way for this to apply ALL filter changes, but for the time being that's going to remain an idea and nothing more.

Thanks for the help and I'm going to label this post SOLVED.