Run VBA code when clicking portion of chart?

[ALJ]

Hello all:

I'm trying to create a tool where if you click on a portion of an area chart, a macro will run to show details for that particular portion of the chart. I know how to make a macro to run when entering or modifying data in a cell, but I'm stumped on how to do it when clicking in a chart. Is this possible? I appreciate any suggestions - thanks!

 

[VoG]

Hello and welcome to MrExcel.

This may help http://www.computorcompanion.com/LPMArticle.asp?ID=221

 

[ALJ]

Thank you - that's perfect!