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.

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

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


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


--
Cheers
Andy

------
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info