EmbeddedPivotChart: Drilldown-Class
Hi Everyone
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.
Thanks
Joe
Software/Hardware used:
MS Excel 2010
Software/Hardware used:
MS Excel 2010
ASKED:
January 16, 2013 3:25 PM
UPDATED:
January 17, 2013 1:40 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Ok, so good news is I managed to remedy that problem, with a simple re-save, close and open again. However I found now on only one of my Charts, if I drill down on the data from what should be row 7 in my Pivot Table, the returned results will be from Row 6. E.g. My Pivot Table has an entry in A7 = 100 and row A6 = 25. The Graph shows correctly that the value for the data in Row 7 is 100. But when you drill down to the original data as per above, the result returned is 25 from row 6. Any ideas?
It seems to be related to the (Axis Field Category) and that I have 2 fields in there….