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

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

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

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