Drilldown from Chart-to-chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
Click to expand...

No, what you want isn't part of Excel's programming. You have to write a
special program to do it.
 
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
 
Back
Top