View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Gwynne Gwynne is offline
external usenet poster
 
Posts: 10
Default Current date (i.e., today()) in Chart Title

Thank's sooo very much! I'm going to try that right now!
Gwynne

"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?