If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2002 chart does not update when worksheet data changes | proquant | Charts and Charting | 1 | June 15th, 2005 12:23 AM |
How can i change the default line weight in an excel chart | Nigel | Charts and Charting | 0 | March 30th, 2005 03:38 AM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Shading a range between two series in a chart | Jon Peltier | Charts and Charting | 0 | May 20th, 2004 03:49 AM |
resizing chart title box Excel 97 | Andy Pope | Charts and Charting | 1 | February 28th, 2004 03:26 AM |