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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Tail Wind" <(E-Mail Removed)> wrote in message
news:A84DAF08-6341-4636-9EF3-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
news:A84DAF08-6341-4636-9EF3-(E-Mail Removed)...
> 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.

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.

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" <(E-Mail Removed)> wrote in message
> news:A84DAF08-6341-4636-9EF3-(E-Mail Removed)...
> > 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.
>
>
>