View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Display current date on chart

In a cell (say D1) enter the formula =TODAY() and format it the way you want
to see the date on the chart.
Click the chart; in the Formula Bar type = and then click D1
You now have a text box showing the date

If using XL2007:
Enter date in cell
Activate chart; use Insert | Text box
With box selected, in the Formula Bar type = and then click D1

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Tail Wind" wrote in message
...
Hi,

How do I display and print today's date on a chart? I currently have an
outlined text box in the upper right corner which I manually update with
today's date.

This seems as if it should be way too easy to do but I cannot find the
answer.

Your help is most appreciated.