Hi
have a look at
http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/ch...nes/index.html
http://peltiertech.com/Excel/Charts/...s.html#AddLine
for adding lines to a chart

HTH
Frank


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 move 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/