Excel DRILLDOWN

[Steve]

How does one create 'DrillDown' features? I cant figure it out.. I have seen
where on clicks a "pie slice" or a "Bar" and it automatically drills down to
another "comprising" chart (data - pie, bar, etc).

Please help!

 

[Steve]

Here's what I want to do:

I have a pie chart that shows (in %) the resource-amounts that certain
components of a computer system are using. Lets say that "Component A" uses
50%. I would want to double-click the "Component A" slice to find out the
pieces that make up HIS totals - "Subcomponent-X, SubCom-Q, etc...".

Thanks in advance if/when help arrives! Hopefully it won't have to be done
in VB, as I have no clue how to do that (less I begin reading the manual now).

 

[Jon Peltier]

You need to set up events for your chart. Here's an introductory article on
chart events:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon

 

[ShaneDevenshire]

Although you can do a pie of pie or a column of pie chart these always show
both charts. For what you ask VBA is necessary.