K
KR
I'm building a workbook and it would be ideal to have 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 some named ranges - so that the 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 might have to distribute the file within our organization to people
without direct access to common servers, so I'd need something that I could
just distribute in the workbook without complicated installations on each
PC.
Has anyone done anything like this within Excel? I appreciate any advice or
pointers.
Thanks,
Keith
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 some named ranges - so that the 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 might have to distribute the file within our organization to people
without direct access to common servers, so I'd need something that I could
just distribute in the workbook without complicated installations on each
PC.
Has anyone done anything like this within Excel? I appreciate any advice or
pointers.
Thanks,
Keith