+ Reply to Thread
Results 1 to 5 of 5

converting X,Y chart points into actual coordinates

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    converting X,Y chart points into actual coordinates

    Hi all. I have the working macros, that extract x,y points from an embedded chart. Now the problem is that x,y points that it gives my is some internal numbers and i dont know how to convert it into actual coordinates (in my case, x - dates, y - some values). So instead of getting x,y points of this chart, i need to get (1/19/2012, 900). Unfortunately, I cant upload the workbook but here the working code:

    to Workbook level:
    Please Login or Register  to view this content.
    and to specially created class module called CChartSink:
    Please Login or Register  to view this content.
    Any help will be highly appreciated.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,235

    Re: converting X,Y chart points into actual coordinates

    Assuming this is an XY scatter plot, it would seem to me that all you need is to get the x, y ID numbers for a couple of points where you know the real X and Y values (maybe lower left and upper right corners of the plot). Once you have the data to relate the internal ID numbers to real numbers for two points, it should be simple linear interpolation to relate the real X Y values for any point on the chart.

  3. #3
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: converting X,Y chart points into actual coordinates

    It's interesting thought. Thank you. I'll try it out and report then results.

  4. #4
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: converting X,Y chart points into actual coordinates

    Here is the report. It works only theoretically. In practice, it didn't work due to excel shortcomings. it's too long to explain. I would say now all this code up there is useless. But thank you a lot for help.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,080

    Re: converting X,Y chart points into actual coordinates

    You need to use the other 3 arguments to determine what was clicked and then extract the values.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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