D DM May 14, 2004 #1 Is it possible to use the noew function in a chart to always show the current time and date?? =NOW() Thanx D
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 May 14, 2004 #2 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
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 May 14, 2004 #3 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)
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)
