How to get the context information of the embedded Excel

[Mahima]

I have a PowerPoint presentation with embedded Excel. This Excel contains
charts. Using macro on PowerPoint I am able to refrence the embedded Excel
and and the charts and copy them as pictures on the slide.
I want to get the contxt information (the XY location ) of the mouse pointer
in order to display the appropriate picture. I have to do this without
activating the embedded Excel.
My end result should be to display context based pictures on mouse hover on
the embedded chart. So Basically, I should be able to get which Bar/Series in
the mouse pointer on, from PowerPoint.

 

[Mahima]

That's a handfull. I doubt very much that it's directly possible.

But you could conceivable prep the slide ahead of time by adding invisible
shapes above the graph and applying MouseOver Run Macro action settings to them.


==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/

In my scenario it will difficult to place the labels, since the charts will
be dynamically created. Can there be any other way to get the Chart's context?