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