How to add line at today's date in chart

[Xelc]

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

 

[Frank Kabel]

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

HTH
Frank

 

[Tom Ogilvy]

I believe Jon Peltier covers this topic on his site:

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

 

[Xelc]

Well, thanx for the web sites but none of the tricks mentioned ther
work properly. Some, like creating a combination chart, have truel
disasterous results!

Guess this can't be done

 

[Andy Pope]

Hi Xelc,

It is possible to create a moving date line on a chart.
Take a look at this example.
(http://www.andypope.info/ngs/ng25.htm)

 

[Xelc]

Thanx for trying Andy, but the same problem persists - you cheated an
added a column of data to the workbook. The goal was to get a datelin
by putting something into a formula (e.g. series3 ={$TODAY()} an
nothing into the spreadsheet itself.

But that's a good reference site, I'll save the link

 

[Andy Pope]

Ok, but I hardly think its cheating when you didn't state the rules

Anyway, you can not use a formula directly in a data series.
However you can use a reference to a named range and the named range can
contain a formula.

Try the example again, which has be modified to use a dynamic range.

 

[Jon Peltier]

Some of the disaster might be due to your monthly data being in months
and today's date being in days. Today's date is 38026, but the month is
only 1248. Completely different scales, if you are trying to put them
together onto a time scale line chart axis.

- Jon