read co-ordinates

[Ciara]

If iv drawn a chart in excel what's the best way to read off co-ordinates?
can i pick a point and get it's co-ords?

Thanks

 

[Jon Peltier]

You can use a class module to capture the click event when you click on
a point. You can then determine the coordinates of the point under the
click. I wrote an article on chart events here:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______