Drilldown from Chart-to-chart

[SC]

Jon Peltier referred me to a doc called the Computor Companion, but I really
don't
see how to do what I want. Hence, I need to ask this again:

I have a simple PIE chart. I want to be able to double-click on one of the
"slices" to DRILL-DOWN to another pie chart that would show its components,
or makeup. Sorry for a repeat question, but is there really a simple way,
without having to write a bunch of code? I've never seen VBA, but if I must
learn, then so be it. Tres dificult!

Thanks very much,
SC

 

[Del Cotter]

I have a simple PIE chart. I want to be able to double-click on one of the
"slices" to DRILL-DOWN to another pie chart that would show its components,
or makeup. Sorry for a repeat question, but is there really a simple way,
without having to write a bunch of code?

No, what you want isn't part of Excel's programming. You have to write a
special program to do it.

 

[Jon Peltier]

I believe I said that you do need code to do what you wanted, and the code
in the article I cited could get you started.

In the section of the article entitled "Identify the Point Clicked By the
User", there is an example using a mouse-up event to jump to another chart.
Find the paragraph that starts with

"Identify the clicked point, then jump to another appropriate chart."

- Jon

 

[Tushar Mehta]

If this is a PivotChart check out
PivotChart Drill-down
http://www.tushar-mehta.com/excel/software/pivotchart_drilldown/index.html