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]

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/newsgroups/dynamic_charts/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]

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.