Here's another, showing how to chart the last 12 months of data:

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

John Mansfield wrote:

Ivan,

You should be able to set the dynamic chart to show just about any range you
want. These articles should help:

http://pubs.logicalexpressions.com/P...cle.asp?ID=518

http://pubs.logicalexpressions.com/P...cle.asp?ID=246

http://pubs.logicalexpressions.com/P...cle.asp?ID=535

----
Regards,
John Mansfield
http://www.pdbook.com

"ivan" wrote:


i need a help please.
i have problem in excel chart. i add data to the table.
and then if i want to update my chart i need to change the range too, isn't
it?
is there any solution for that? i've already use dynamic chart. but it always
show data from Jan04 till Jan05. If I add Feb05 it will change from Feb04 to
Feb05.
what about if i want to see Dec03 till Dec04? is there any command or
something else like using macro or vb? thank you in advance..

ivan