• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

PivotChart Drill Down

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
 
Top