# converting X,Y chart points into actual coordinates

1. ## 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.  Register To Reply

2. ## 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.  Register To Reply

3. ## Re: converting X,Y chart points into actual coordinates

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

4. ## 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.  Register To Reply

5. ## 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.``  Register To Reply