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.
|