+ Reply to Thread
Results 1 to 5 of 5

Chart Point Coordinates from Plot Picture

  1. #1
    Registered User
    Join Date
    06-06-2022
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    5

    Question Chart Point Coordinates from Plot Picture

    I have some plot pictures (i.e. PNG files) for which I want to generate XY points that I can use to create XY scatter charts and, ultimately, trendline formulae. Once I get the XY point coordinates I can do the rest, including converting the Excel point coordinates to plot coordinates (mine are decibels vs. decibels). I fooled around with dropping curve points on the plot pictures and it works great, but do I really need to use VB to get the point coordinates? It would be great if there was a way to right-click something and get the point coordinates, even if I had to do it for every point individually. If I need VB, though, I could use a hint of what function to use. Thanks!
    Last edited by jefflabuz; 06-06-2022 at 10:30 AM.

  2. #2
    Registered User
    Join Date
    06-06-2022
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Chart Point Coordinates from Plot Picture

    Here's the Excel file showing where I'm stopped. The stuff below the plot image was my crude attempt to approximate the point coordinates by eyeball.
    Last edited by jefflabuz; 06-06-2022 at 10:34 AM.

  3. #3
    Registered User
    Join Date
    06-06-2022
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Chart Point Coordinates from Plot Picture

    My plot figure is dBm vs. dBm, which I will convert later to dB (gain) vs. dBm (input power), not that that's pertinent to my original question.

  4. #4
    Registered User
    Join Date
    06-06-2022
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Chart Point Coordinates from Plot Picture

    So this thread describes something close to what I need. At least it looks like I could make it work.
    677831-find-coordinates-of-point-clicked-relative-to-picture-edges

  5. #5
    Registered User
    Join Date
    06-06-2022
    Location
    Massachusetts, USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Chart Point Coordinates from Plot Picture

    Well, "physician, heal thyself"? It's crude, but using the image control feature described in that "677831-find-coordinates..." thread I managed to get something satisfactory, if not as automated as I'd like. I'm attaching my (now macro enabled) file that shows the point coordinates (Y-Y) I obtained, the mapping from chart coordinates to Pout vs. Pin (dBm-dBm) plot coordinates, then to Gain vs. Pin (dB-dBm) plot coordinates, and the chart of Gain vs. Pin plot coordinates with two polynomial trendlines: a 4th order one for the first five data points (green) and a 6th order one for the last 13 data points (blue) where the 5th data point is used for both trendlines. I'll switch between the two trendline formulae at their Pin = -3.5 dBm crossing. If anyone has a more elegant way of getting chart coordinates from plot images then I'd love to hear it!
    Last edited by jefflabuz; 06-06-2022 at 01:04 PM.

+ 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. Dynamic Scatter Plot Chart Picture
    By RuKeBo in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 12-17-2020, 05:24 PM
  2. X and Y coordinates, locating closest Point to point distance.
    By Erav in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2020, 04:02 PM
  3. Replies: 6
    Last Post: 05-28-2018, 01:39 PM
  4. find coordinates of point clicked, relative to picture edges
    By adrianke77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2009, 01:52 AM
  5. Finding starting point of chart plot area
    By rweatherly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2008, 10:54 AM
  6. Convert point coordinates -> pixel coordinates
    By Zorro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2006, 10:30 PM
  7. [SOLVED] How to get x,y coordinates of point from scatter chart in VBA
    By Milo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2005, 08:25 PM

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