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/Pub0009/LPMArticle.asp?ID=518

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=535

 

[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/
_______