#1   Report Post  
Ciara
 
Posts: n/a
Default 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
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My speadsheet won't change out of Read Only - Help!! Shelley Parkin Excel Discussion (Misc queries) 3 June 15th 05 01:58 AM
Make excel open file without Read Only dialog Saul Margolis Excel Discussion (Misc queries) 2 March 16th 05 03:30 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
cannot save file - folder is read only BigDog Excel Discussion (Misc queries) 1 December 7th 04 11:18 PM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 01:22 AM


All times are GMT +1. The time now is 03:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"