Excel DRILLDOWN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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).
 
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.
 
Back
Top