Inserting Date into chart

  • Thread starter Thread starter Jas2be
  • Start date Start date
J

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
 
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.
Click to expand...

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