Display current date on chart
 

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.

Answer: Display current date on chart
 

Displaying the current date on a chart in Excel

1. Click on the chart to select it.
2. Click on the "Layout" tab in the ribbon at the top of the screen.
3. Click on "Text Box" in the "Text" section of the ribbon.
4. Click and drag to draw a text box where you want the date to appear on the chart.
5. Click inside the text box and type
   Code:

   ---

   =TODAY()

   ---

   (without the quotes).
6. Press Enter.

That's it! The current date will now appear in the text box on the chart. If you want to format the date differently, you can do so by right-clicking on the text box and selecting "Format Text Box". From there, you can change the font, size, color, and other formatting options.

I hope that helps!

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.

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.

Display current date on chart
 

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.

"Tail Wind" wrote:

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.

Display current date on chart
 

Thanks. It was easy after all!


"Jon Peltier" wrote:

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.