Display current date on chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Type into a cell =now(). Ths will give you both the date and time but, if
this is too much information, you can use the number formatting to chnge this
to how you want to display it.
 
Thanks. It was easy after all!


Jon Peltier said:
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
_______
Click to expand...
 
Back
Top