chart drill down

[jerry Rosenberg]

Is it possible in Excel to "drill down" to another chart?
For example, if I create a 24 hour stacked bar graph, can
I select one hour and switch to a side by side view of
only that hour.
I understand that I would probably have to create these
other views and just swap between views. I would like to
do this in a "clickable" fashion.

Thanks

 

[Jon Peltier]

Jerry -

You can write event procedures for chart events. It's easiest for chart
sheets, because each sheet has a code module. You can do it for embedded
charts too, but you need a separate class module to contain all the
event procedures. Microsoft's Knowledge Base article 161858, How to Trap
Events for an Embedded Chart, explains how to do this. Read the article
at http://support.microsoft.com.

You would then set up your procedures so that if the user clicked on the
data point for the fifth month, the procedure would jump to the chart
for the fifth month.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______