I'm building a workbook and it would be ideal to maintain a smaller number
of
graphs (versus hundreds) where if I click on a data element (pie wedge or
bar) it would tell excel which element was clicked, so I could use that to
update the same graph through named ranges - so that the same graph updates
with the component pieces of that single data element, e.g.:

Chart shows Revenue from meat, fruit, dairy, breads
<click on dairy
Chart now shows Revenue from milk, eggs, cheese, butter
<click on cheese
Chart now shows Revenue from Cheddar, Mozerella, Colby, Swiss
<click on cheddar
Chart now shows Revenue from sliced, bar, shredded (8oz), shredded (16oz)
(and maybe some way to click back out to each higher level)

Since I haven't found a way to do this within Excel 2003, can anyone suggest
(hopefully inexpensive) controls that I could add to my workbook to do this?
I'd prefer a control that I could distribute with the workbook to multiple
users,
but even if I have to keep it in one workbook and stick in on a network
directory, at least I'd have the functionality I need.

Has anyone done anything like this within Excel? I appreciate any advice or
pointers.
Thanks,
Keith



--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.

Hi,

This article by Jon Peltier might help you with your problem.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

It cover chart events. You will still need to develop code in order to
update the actual content. You maybe to achieve some of this by the use
of charted dynamic ranges.

Cheers
Andy

KR wrote:
I'm building a workbook and it would be ideal to maintain a smaller number
of
graphs (versus hundreds) where if I click on a data element (pie wedge or
bar) it would tell excel which element was clicked, so I could use that to
update the same graph through named ranges - so that the same graph updates
with the component pieces of that single data element, e.g.:

Chart shows Revenue from meat, fruit, dairy, breads
<click on dairy
Chart now shows Revenue from milk, eggs, cheese, butter
<click on cheese
Chart now shows Revenue from Cheddar, Mozerella, Colby, Swiss
<click on cheddar
Chart now shows Revenue from sliced, bar, shredded (8oz), shredded (16oz)
(and maybe some way to click back out to each higher level)

Since I haven't found a way to do this within Excel 2003, can anyone suggest
(hopefully inexpensive) controls that I could add to my workbook to do this?
I'd prefer a control that I could distribute with the workbook to multiple
users,
but even if I have to keep it in one workbook and stick in on a network
directory, at least I'd have the functionality I need.

Has anyone done anything like this within Excel? I appreciate any advice or
pointers.
Thanks,
Keith




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy-

Thanks for the link- I hadn't seen this before, but it looks like it will do
exactly what I need :)

Best regards,
Keith

"Andy Pope" wrote in message
...
Hi,

This article by Jon Peltier might help you with your problem.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

It cover chart events. You will still need to develop code in order to
update the actual content. You maybe to achieve some of this by the use
of charted dynamic ranges.

Cheers
Andy

KR wrote:
I'm building a workbook and it would be ideal to maintain a smaller
number
of
graphs (versus hundreds) where if I click on a data element (pie wedge
or
bar) it would tell excel which element was clicked, so I could use that
to
update the same graph through named ranges - so that the same graph
updates
with the component pieces of that single data element, e.g.:

Chart shows Revenue from meat, fruit, dairy, breads
<click on dairy
Chart now shows Revenue from milk, eggs, cheese, butter
<click on cheese
Chart now shows Revenue from Cheddar, Mozerella, Colby, Swiss
<click on cheddar
Chart now shows Revenue from sliced, bar, shredded (8oz), shredded
(16oz)
(and maybe some way to click back out to each higher level)

Since I haven't found a way to do this within Excel 2003, can anyone
suggest
(hopefully inexpensive) controls that I could add to my workbook to do
this?
I'd prefer a control that I could distribute with the workbook to
multiple
users,
but even if I have to keep it in one workbook and stick in on a network
directory, at least I'd have the functionality I need.

Has anyone done anything like this within Excel? I appreciate any advice
or
pointers.
Thanks,
Keith




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info