Thread: How to add line at today's date in chart
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How to add line at today's date in chart
I believe Jon Peltier covers this topic on his site:

http://PeltierTech.com/Excel/Charts/

--
Regards,
Tom Ogilvy



"Xelc " wrote in message
...
I'm looking to add a vertical line at today's date in a chart. The X
axis is using monthly data and I would actually settle for today's
month, though it would be nice to have the line moSve throughout the
month.

Series1 points to 6/1/03, 7/1/03 ... 6/1/04
Series2 points to relevant data

I tried setting series3 to ={$TODAY()} but that did not work.

Did not find anything useful googling. Any ideas?


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote