date at chart

[external]

I am using MS EXCEL 2003.
I want to add date dynamicly (only MONTH)to a chart.
How can i do this?

[Tushar Mehta]

In article <[email protected]>,
[email protected] says...
>
> I am using MS EXCEL 2003.
> I want to add date dynamicly (only MONTH)to a chart.
> How can i do this?
>
>
Given the brevity of your question, about the best I can suggest is that you
look at
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

[external]

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

[Del Cotter]

On Sun, 23 Jul 2006, in microsoft.public.excel.charting,
external <[email protected]> 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 [email protected],
which goes to a spam folder-- please send your email to del3 instead.