Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Pivot Chart Drilldown

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 || ||
http://code.comparative-advantage.com

  #2   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Pivot Chart Drilldown

No takers?

  #3   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Pivot Chart Drilldown


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 || ||
http://code.comparative-advantage.com

  #4   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Pivot Chart Drilldown


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 || ||
http://code.comparative-advantage.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customizing a Pivot Chart JWalker Charts and Charting in Excel 1 February 18th 06 10:13 PM
Pivot chart issue James Charts and Charting in Excel 8 September 13th 05 12:35 PM
Pivot Chart - default chart type Rav99 Excel Discussion (Misc queries) 4 September 6th 05 01:20 AM
pivot chart format Valeria Charts and Charting in Excel 1 January 14th 05 01:19 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"