View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Current date (i.e., today()) in Chart Title

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?