John - thanks for the response. The only problem is my chart is embedded in
a worksheet, so I guess I will have to use a class module to setup my event
procedures.
"John Mansfield" wrote:
Wazooli,
Take a look at Jon Peltier's article on chart events . . .
http://www.computorcompanion.com/LPMArticle.asp?ID=221
then, take a look at this post . . .
http://www.pdbook.com/index.php/excel/comment/635/
Referencing Jon's article, I think you will need to add the xlDataLabel
element to the event as described in the comments at pdbook.com.
Hope this helps.
----------------------------
Regards,
John Mansfield
http://www.pdbook.com
"Wazooli" wrote:
Can anyone explain how x-y coordinates for points within a chart can be
accessed via a mousemove event? I realize this will require quite a bit of
coding, but I would like a little comment box to appear for any given point
on an X-Y scatter I have. The data set consists of around 27000 points, and
I would like the mousemove event to trigger a lookup into a table that
contains a fairly lengthy descripion of each point.
Wazooli