Revised Date

[DM]

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

=NOW()


Thanx
D

 

[Jason Morin]

You could insert a text box from the Control Toolbox (View

Toolbars). Create the text box on the chart, right

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

 

[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)