Let me start off by saying I'm a complete Noob when it comes to this, so I hope my explanation makes sense...
I've been trying to implement the Embedded Pivot Chart Drilldown Class as explained by Craig Hatmaker on the YouTube video :http://www.youtube.com/watch?v=-Uu2WqDxLdk
Firstly, the video was excellent and very informative, and the example files definitely helped and provided me with the results I wanted.
However, it seems that for some unknown reason my chart gets disconnected from my class after running the command once. So basically I have some PivotCharts displayed on a Dashboard Worksheet. I would click in on of the Pivot Charts on a value and the original data will be displayed on the new worksheet "Drilldown" created as explained at https://dl.dropbox.com/u/13737137/Projects/Drilldown/Chart_Drilldown_Embedded.pdf
The next data point I click on in my Pivot Chart however does not update the new Worksheet "Drilldown" and only the original query's data remains. This then requires me to go into VBA and run the Sub/ User Form again.
Please, can someone assist? My VBA commands are exactly as per the example on the above mentioned link.
Software/Hardware used: MS Excel 2010
Ask a Question
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!