ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   read co-ordinates (https://www.excelbanter.com/charts-charting-excel/33761-read-co-ordinates.html)

Ciara

read co-ordinates
 
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 he

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

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


Ciara wrote:

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



All times are GMT +1. The time now is 01:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com