If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
stock chart category axis
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 |
#2
|
|||
|
|||
stock chart category axis
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 |
#3
|
|||
|
|||
stock chart category axis
"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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
label the category axis from 0 to 30, step 5 in an excel chart | johnny hanlon | Charts and Charting | 2 | January 29th, 2006 12:12 AM |
How do I make the Y axis in an excel chart the category axis? | megnadoodle | Charts and Charting | 2 | March 29th, 2005 09:27 AM |
Timeline chart from text containing cells | K. Georgiadis | Charts and Charting | 6 | June 8th, 2004 12:19 AM |
Clustered Column Chart with Second Axis | Jon Peltier | Charts and Charting | 0 | April 10th, 2004 04:56 AM |
Category Axis Area in Bar Chart Cuts Words Apart on Wordwrap | Viper | Charts and Charting | 1 | September 28th, 2003 02:31 AM |