Macros on Bar Graphs?

I have a bar graph that I would like to respond to a macro.

Consider a frequency bar graph. I.e., it displays the number of occurrences of something over a domain like [0, ... , M].

Event 0 has Freq(0), event 1 has Freq(1), ... , Event M has Freq(M).

I would like to click (or maybe right-click) on the bar of Event K and run a macro that uses K as its input parameter. Is this in any way possible?

Thanks!

Bruno in Omaha.

Originally Posted by adyteo

have a look here:
http://social.msdn.microsoft.com/For...forum=exceldev

Thank you. This greatly helped me solve my problem.