Current date (i.e., today()) in Chart Title
Hi,
I felt so lucky that someone had answers for exactly what I want to do.
But, I still have some issues in following your steps.
I entered the date in cell A1. Then, I clicked the border of the Chart
Title. But, where should I type "=A1"?
I typed "A1" into the function box (Fx) but an error message occur.
"The formula you typed contains an eorr. Try one of the following:
-Make sure you've included all parentheses and requred arguments
-To get assistance iwth using a function, click Function (Insert Menu)
....
....
Did I type the "=A1" in wrong place?
"Shane Devenshire" wrote:
Hi,
In a cell, say A1, in the spreadsheet enter a formula like this:
=TEXT(TODAY(),"M/D/YY")
Now select the border of the chart title, not inside, and type =A1
when you press enter the title will use the value in cell A1 for your title.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Gwynne" wrote:
Is there a way to insert a date code/command in the Chart Title?
|