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:
and to specially created class module called CChartSink:
Any help will be highly appreciated.
Bookmarks