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