G Guest Jul 5, 2005 #1 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
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
J Jon Peltier Jul 5, 2005 #2 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/ _______
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/ _______
