Drilldown from Chart-to-chart
 

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

Drilldown from Chart-to-chart
 

On Thu, 1 Mar 2007, in microsoft.public.excel.charting,
SC said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Drilldown from Chart-to-chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"SC" wrote in message
...
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

Drilldown from Chart-to-chart
 

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

"SC" wrote in message
...
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