EmbeddedPivotChart: Drilldown-Class

50 pts.
Tags:
Microsoft Excel 2010
VBA
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BigJoe23
    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?
    50 pointsBadges:
    report
  • BigJoe23
    It seems to be related to the (Axis Field Category) and that I have 2 fields in there....
    50 pointsBadges:
    report
  • RunningDog
    Hi Joe, did you ever find out the answer to your question posted on Jan 16 regarding getting the wrong row # when drill down on a chart with 2 Axis fields? I just ran into this problem myself and have been scratching my head after trying different things to debug it. Appreciate anything you found on this.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following