Drill down on Bat Charts

[fernmp]

I have a bar chart that I want to be able to drill down on. I want t
click the actual bar and go to a summary data panel of the data tha
was used to create the bar, or even better, add a macro so that I ca
pop-up detailed data.

I know I can can draw a rectangle over the bar and add a Hyperlink, bu
the problem there is that the bar size is totally variable.

Any ideas folks?


Marti

 

[Jon Peltier]

You can use chart events to detect when a data point (i.e., bar) is clicked, and use
the event procedure to simulate a hyperlink. I have some rudimentary examples of
chart events on my web site:

http://peltiertech.com/Excel/Zips/GetXYonaChartSheet.zip
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

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