Pivot Chart Drilldown

J

james.igoe

I am working on a chart drilldown - I use drilldown to mean that a
Shift+Click opens the underlying data into a separate tab - and
although the event module I've coded works for 1 row by 1 column pivot
charts with any number of pages, I am having issues with drilling down
into more complex charts.

Currently, I am using the series collection, the MouseUp chart event,
as well as features of the active chart, but I am struggling with a
more elegant way to execute complex drilldowns.

Any ideas?


James Igoe

646.303.2584 || (e-mail address removed) ||
http://code.comparative-advantage.com
 
J

james.igoe

I eventually solved my problem, still using the MouseUp event but I
extended the information collected and eventually was able to solve my
problem adequately.

If interested, visit my website and find it among my Excel VBA
offerings.

James Igoe

646.303.2584 || (e-mail address removed) ||
http://code.comparative-advantage.com
 
J

james.igoe

I eventually solved my problem, still using the MouseUp event but I
extended the information collected and eventually was able to solve my
problem adequately.

If interested, visit my website and find it among my Excel VBA
offerings.

James Igoe

646.303.2584 || (e-mail address removed) ||
http://code.comparative-advantage.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart Drilldown 1
Embedded Chart Versus Chart - ShowDetail Issue 1
pivot table from recordset - very slow performance 1
Embedded Chart Versus Chart - ShowDetail Issue 1
consolidate charts from multiple pivot tables 0
Pivot Chart won't refresh! 3
Formatting pivot chart axis labels for dates 10
Remove series from Pivot Chart 2

Top