| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
| Excel should have an open/close high/low chart for stock market u. | Charts and Charting in Excel | |||
| dynamic range for excel chart | Excel Discussion (Misc queries) | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Linear Mode
