Excel DRILLDOWN
 

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!

Excel DRILLDOWN
 

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).



"Steve" wrote:

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!

Excel DRILLDOWN
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Steve" wrote in message
...
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).



"Steve" wrote:

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!

Excel DRILLDOWN
 

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.

--
Cheers,
Shane Devenshire


"Steve" wrote:

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).



"Steve" wrote:

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!