Drill Down option in Charts

[Nits]

After I create a bar chart. I need to be able to click on
any bar and drill down on the data for that bar.

How do I identify using macros which bar was click so that
I can show the relevant data?

I'm able to click on charts and do thing programmatically
but how do I trigger a data point click event.

Thanks,
Nits

 

[Jon Peltier]

Nits -

There are two examples on my web site:

http://peltiertech.com/Excel/Charts/chartvba.html#PointInfo

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