View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Xelc Xelc is offline
external usenet poster
 
Posts: 1
Default How to add line at today's date in chart

I'm looking to add a vertical line at today's date in a chart. The
axis is using monthly data and I would actually settle for today'
month, though it would be nice to have the line move throughout th
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