select chart point trigger macro

[Dirt]

Can I select a point on a chart and have it trigger a macro? (pop up, etc.) for example on a control chart. I would like to click the point beyond control limits and have it trigger a macro that allows annotation.
TIA,

D

 

[pgc01]

Hi Dirt
Welcome to the board

Yes you can. You can use the chart events, directly in the case of a chart sheet, or enable them in the case of an embedded chart.

In the case you describe, you can use the MouseDown() event. It will give you the location of the mouse click and you can then do whatever you want.

You must be able to program in vba.

You can read this ms article, that explains how to do it (click also inside in "Chart Object Events") :

http://msdn.microsoft.com/en-us/library/bb211434.aspx


For a detailed explanation, you have this Jon Peltier article, where he explains step by step how to do it:

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

 

[Dirt]

Thank you, that is exactly what I needed!

D