Clickable graphs within excel or some type of add-on? activeX?

[KR]

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]

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]

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