Hi,

Have a look at Jon Peltier's article on chart events.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

Once you know the point and series you should be able to get the date value.

Cheers
Andy

Bill wrote:
I have a high-low-close chart in Excel with 120 days of data plotted against
the date.

I select a point eg a low.

Now, I need to be able to return the date of this low to another cell so
that I can find this date
in the spreadsheet and make further calculations from there.

Any suggestions on how to do this? Is it possible?

I tried in microsoft.public.excel.programming but no response.
a VBA solution is fine, in fact, any suggestion is welcome.

Thanks

Bill




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info