Hi,

Explanation with respect to the chart title, but will work will all
chart text boxes and data labels and user added textboxes.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

diablo wrote:
"Don Guillett" wrote in message
...

You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
.. .


I tried what you suggest but I only see what I typed, =$g$1 which is the
cell that contains the date. I used a rectangle shape. I had tried this
already with a text box as well, it didn't work either.

Thanks,
Brian