View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
MAPLE MAPLE is offline
external usenet poster
 
Posts: 3
Default 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?