date at chart

i looked those links.But i didnt solve my problem.
Please help me
thankss...

On Sun, 23 Jul 2006, in microsoft.public.excel.charting,
external <external.2beaqq_1153653004.8858@excelforum-nospam.com> said:

>i looked those links.But i didnt solve my problem.
>Please help me
>thankss...

Nobody can help you if you don't describe your problem more fully.

Is it that you want the month to display on your chart? Try creating a
cell with the formula

=TODAY()

then format it with the custom format "mmmm", so that it shows "July".

Now create a text box in your chart, and (this is the tricky bit) use
the edit bar to make the box refer to the cell you made. It's no good
just typing "=A1" into the text box itself, that will just show "=A1".

Now your text box should show "July" on the chart, and next month it
will show "August", and so on.

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.