Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart coordinates (97 SR-1)

    Hello,

    I am looking for a program that will be able to provide me with the XY coordinates in my active chart. For example, I have a chart of speed vs. time. What I would like to do is point with the mouse cursor anywhere in the chart and get the (speed, time) values. I have close to a hundred of these charts that I have to go through in Excel, and for each I only need one to two (speed, time) values. Any help would be greatly appreciated.

    Thanks, Hanan.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart coordinates (97 SR-1)

    So why can't you use the source data?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Chart coordinates (97 SR-1)

    Try the Free addin. It finds any coordinate on the chart, whether it has a point attached to it or not.

    http://www.byalexv.co.uk/index.html?GraphCo.html

    Steve

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart coordinates (97 SR-1)

    Thank you for providing me with the link, and for the fast respose. This is exactly what I was looking for. I can not use the original data because I am looking for XY values between the graphed data. For a non-linear relationship, a linear interpolation between the two values would not be appropriate.

    By the way, is there a program to change the XY scales of the current chart (zoom in/out) by means of slider bars?

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Chart coordinates (97 SR-1)

    Is this what you are looking for. Here is a simple example of using a slider bars to set the X/Y max. It is relative it goes form 0 to 10x the autoscale. They also could be set up absolute. You could also setup something similar with 4 "spinner"s (XMin, XMax, YMin, YMax) and again absolute or relative to the "autoscale"

    Regarding your original question. If you have points and a curve, you could CALCULATE a "Y" value given an "X" (or vice-versa) with an equation. You can even have a graphical interpretation of this. I have added another range which given an X draws a line from (X,0) to (X,Y) to (0,Y) and adds a label of the coordinates on the chart. You can add a "spinner" to control the "X" value and the coords will change. This does NOT even require any coding, just formulas. You do need the equation of the "curve" though even that can be calculated directly in most cases without any code.

    Steve

Posting Permissions

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