Mike Toryfter
New Member
I have a worksheet with multiple PivotCharts. I want to be able to click on a column (series) on my PivotChart and get the details...simulating the double-click event that happens on a PivotTable.
I found this post on YouTube from Craig Hatmaker demonstrating how to do this if the PivotChart is an object on it's own worksheet, but I want to allow the user to click any series on any PivotChart on my dashboard worksheet and get the details.
Here's the video:
http://youtu.be/-Uu2WqDxLdk
If you click on the "Show More" below the video, you'll find the VBA code.
After some searching, I did find some work Anthony Paulson did, kind of along these lines, but not PivotChart specific...if this helps.
http://www.mrexcel.com/forum/showthread.php?t=45004
I found this post on YouTube from Craig Hatmaker demonstrating how to do this if the PivotChart is an object on it's own worksheet, but I want to allow the user to click any series on any PivotChart on my dashboard worksheet and get the details.
Here's the video:
http://youtu.be/-Uu2WqDxLdk
If you click on the "Show More" below the video, you'll find the VBA code.
After some searching, I did find some work Anthony Paulson did, kind of along these lines, but not PivotChart specific...if this helps.
http://www.mrexcel.com/forum/showthread.php?t=45004