software

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.
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:
gt; I have a high-low-close chart in Excel with 120 days of data plotted against
gt; the date.
gt;
gt; I select a point eg a low.
gt;
gt; Now, I need to be able to return the date of this low to another cell so
gt; that I can find this date
gt; in the spreadsheet and make further calculations from there.
gt;
gt; Any suggestions on how to do this? Is it possible?
gt;
gt; I tried in microsoft.public.excel.programming but no response.
gt; a VBA solution is fine, in fact, any suggestion is welcome.
gt;
gt; Thanks
gt;
gt; Bill
gt;
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


quot;Andy Popequot; gt; wrote in message
...
gt; Hi,
gt;
gt; Have a look at Jon Peltier's article on chart events.
gt; www.computorcompanion.com/LPMArticle.asp?ID=221
gt;
gt; Once you know the point and series you should be able to get the date
gt; value.
gt;
gt; Cheers
gt; Andy
gt;
gt; Bill wrote:
gt;gt; I have a high-low-close chart in Excel with 120 days of data plotted
gt;gt; against the date.
gt;gt;
gt;gt; I select a point eg a low.
gt;gt;
gt;gt; Now, I need to be able to return the date of this low to another cell so
gt;gt; that I can find this date
gt;gt; in the spreadsheet and make further calculations from there.
gt;gt;
gt;gt; Any suggestions on how to do this? Is it possible?
gt;gt;
gt;gt; I tried in microsoft.public.excel.programming but no response.
gt;gt; a VBA solution is fine, in fact, any suggestion is welcome.
gt;gt;
gt;gt; Thanks
gt;gt;
gt;gt; Bill
gt;gt;
gt;gt;
gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; 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