How to add line at today's date in chart

  • Thread starter Thread starter Xelc
  • Start date Start date
X

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
 
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
 
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
 
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.
 
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
 
Back
Top