View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Display current date on chart

Put the date in a cell. Select the chart, click in the formula bar, type =
and then select the cell. You will get a link like =Sheet1!$A$1. Press Enter
and Excel will place a textbox in the middle of the chart, linked to this
cell. Position and format this textbox as desired.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


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