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

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

"Andy Pope" wrote in message
...
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

Andy

Thanks so much for the URL. Looks like I'll be able to use a technique
suggested therein.

But its bedtime now, so I'll give it a lash tomorrow!!

Thanks again

Bill