Inserting Date into chart

[Jas2be]

How would I go about inserting the current date into a
chart? I would like it to appear in the upper right hand
corner. I want to use the =today() function or something
similar. I have tried using a text box but that does not
work.

Thanks

 

[dvt]

How would I go about inserting the current date into a
chart? I would like it to appear in the upper right hand
corner. I want to use the =today() function or something
similar. I have tried using a text box but that does not
work.

Put =TODAY() in a cell. Let's say that cell is Sheet1!A1. Now selectthe
chart by clicking on it. Then click in the function bar and type
=Sheet1!A1. Alternatively, type the equal sign (=) and then select the
cell of interest. Now you should have something that looks like a text
box but displays the contents of cell A1 on Sheet1.