View Single Post
  #2   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

Right click on the chart tab, click on view code, and enter the following
code:

Private Sub Chart_Activate()

ActiveChart.ChartTitle.Characters.Text = Date

End Sub



- Mangesh



"FJ Shepley & JM Pfohl" wrote in message
...
ex..... Sales for May 14


How do I put a the current date in the title of the chart above so it

comes
up automatically?
I'm thinking something like ..=now() but not sure how put in the title.

Then how do I change the =now() (or whatever is used) to the date it is
saved?

Thanks,
Frank.