• 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


  • 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:


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.