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.