Vertical line in excel chart and lookup
Hello Everyone
Please I need major help!
I want to lookup which period we are in based on today's date. The data below is the period dates. I then want to creat a vertical line for that period in an excel chart. Can this be done? thanks in advance
P1 01/04/2009 30/04/2009
P2 01/05/2009 31/05/2009
P3 01/06/2009 30/06/2009
P4 01/07/2009 31/07/2009
P5 01/08/2009 31/08/2009
P6 01/09/2009 30/12/2009
Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!
2 posts - 2 rules ignored - please ensure you read the rules before posting any further.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks