Get chart coordinate

[boh]

Hi
I have made a X-Y-chart with a map as background in EXCEL and linked that to
a slide in PPT2002.
I would like to click on the map during slideshow and get chart coordinates
or the longitde/latitude for the point. In the end I want to calculate for
example the distance to the closest X-Y-point.
I know how to get the mouse position at click and how to convert pixels to
points, but I can't figure out how to convert the point to chart-coordinates.
Any ideas?

Thanks / boh

 

[boh]

Hi Steve and thanks a lot for your response.
I can see your solution but I think it's an uncertain solution thats depends
on manuel update of the code every time I change my map/data.
I have read somewhere that EXCEL copy the entire source workbook to PPT. If
so, is it possible to get a reference to the EXCEL object "Chart 1" in PPT?
If I have a reference to "Chart 1", it ought to be possible to get
Axes(xlValue).MinimumScale, Axes(xlValue).MaximumScale..... and, with some
math, convert points to chart-coordinates. Am I completely wrong? Or have
someone a good solution to my problem. Thanks in advance / boh


"Steve Rindsberg" skrev: