Click Chart Bar to Load Form

[fprzekop]

My goal is to be able to click or hover over a bar or slice on a chart and have a Form show detail related to the "selected" bar or slice (it could either load a form or update a loaded form).

I see that you can enable event procedures for embedded charts using a class module... but that's as far as I've gotten. The available events don't seem to support a bar click/hover type action by the user.

Ideas or hints much appreciated.

 

[Andrew Poulsom]

There is a MouseMove event but it's a bit clunky. Here's an example that uses MouseDown and MouseUp:

http://www.mrexcel.com/forum/showthread.php?t=45004

 

[fprzekop]

Thanks Andrew. Got your code to work. Now just need to modify to display detail on a form. Thanks