Revised Date

D

DM

Is it possible to use the noew function in a chart to
always show the current time and date??

=NOW()


Thanx
D
 
J

Jason Morin

You could insert a text box from the Control Toolbox (View
Toolbars). Create the text box on the chart, right
Click to expand...
click, and go into Properties. Put in a cell reference
like E1 in "LinkedCell". And put this in cell E1:

=TEXT(NOW(),"mm/dd/yy h:mm AM/PM")

Of course the text box won't update until a re-calc is
done on the worksheet.

HTH
Jason
Atlanta, GA
 
F

Frank Kabel

Hi
try the following
- insert a textbox in your chart
- select the checkbox in click in the formula bar
- enter the formula directly in the formula bar (not in the text box)
 
Top