+ Reply to Thread
Results 1 to 5 of 5

Finding graph X,Y coordinates using Mouse Cursor

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner VA USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,548

    Re: Finding graph X,Y coordinates using Mouse Cursor

    Welcome to the Forum!

    I don't know of a way to do this with the cursor but it could be done by interpolation using the source data. I'm assuming that the graph is in Excel, generated by data in Excel. The accuracy of the interpolation would depend on how close together the data points are, but just by eyeballing it, it looks like linear interpolation would be a good approach here.

    You can get fancier by using macros to do the interpolation based on some Y value you select, so it could be interactive.

    I could provide a more concrete answer if you can attach your file. Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  2. #2
    Registered User
    Join Date
    02-25-2017
    Location
    Limerick, Ireland
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Thumbs up Re: Finding graph X,Y coordinates using Mouse Cursor

    Hi 6StringJazzer and thank you!

    I've attached a file. It's not the original as I've some sensitive data in their which I can't give out... (or men in suits might come to my door and shoot me ).

    However, this file should explain my problem. Thank you for your help so far.
    Cheers,

    Fionn

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding the x y coordinates by using mouse over.
    By DNA007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2012, 06:33 PM
  2. Finding the x y coordinates by using mouse over.
    By DNA007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2012, 03:27 PM
  3. Mouse Coordinates in userform
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2008, 04:57 AM
  4. [SOLVED] Mouse X-Y Coordinates
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2006, 11:40 PM
  5. [SOLVED] Can I grab graph coordinates in Excel via the mouse with VB?
    By Chris Manning in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-21-2005, 10:05 PM
  6. [SOLVED] finding the coordinates of the maximum point on a graph
    By eastham85 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2005, 10:06 AM
  7. Mouse coordinates
    By Fustin Fran癟ois in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2005, 10:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1