View Single Post
  #4   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

Shane, I did exactly what your answer said and it worked great! However, the
Date is now the entire title of my chart what is not exactly what I need. I
need the title "WIA Disbursement and and Budget Summary - June 17, 2009".
Can you help with this?

Thanks#

"Gwynne" wrote:

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?