how to change range for dynamic chart in excel 2000 with button?

[ivan]

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

[John Mansfield]

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

[Jon Peltier]

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