stock chart category axis

[Bill]

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]

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]

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

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