I am using the idea from this Excel document, but I am unsure on how the 9 Box chart is connected to the splicer?
I am using the idea from this Excel document, but I am unsure on how the 9 Box chart is connected to the splicer?
Hi!
It's connected by VBA. Press Alt+F11 to open it, apparently this workbook uses Two Modules:
ModMakeChart & Module2
Cheers!
John.
"I excel at jumping to conclusions"
The splicer updates the pivot table on the lookup sheet, which in term then runs the event code within that sheet object.
This then calls the routine MakeChart
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks