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
|
|||
|
|||
watch a curve change over time like a movie
I would like to be able to view my data set such that I can view the curve
change over time instead of viewing for example 10 curves on one graph. I would like to be able to select the speed at which the curve is refreshed (new data set), and the direction (so I can run the curve forward and backward in time). In essence, I have monthly data that represents one curve. I would like to visually watch the curve change month by month instead of plotting one curve for each month, I see one graph with the curve in motion over my data set (time). |
#2
|
|||
|
|||
Randy -
You set this up with defined names, such that the Y values is defined based on an integer value in another cell. Something like Name: YValues RefersTo: =Offset(Sheet1!$A$2:$A$12,0,Sheet1!$E$1) As the value in E1 increases, the range defined by the Offset is further and further to the right. Your chart is based on these YValues. Then you have a macro that moves forwards or backwards through the data by changing the value in E1 by a certain amount after a given delay. Shorter delays mean the curve changes more quickly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RandyBarrett wrote: I would like to be able to view my data set such that I can view the curve change over time instead of viewing for example 10 curves on one graph. I would like to be able to select the speed at which the curve is refreshed (new data set), and the direction (so I can run the curve forward and backward in time). In essence, I have monthly data that represents one curve. I would like to visually watch the curve change month by month instead of plotting one curve for each month, I see one graph with the curve in motion over my data set (time). |
#3
|
|||
|
|||
For a solution that uses iteration (it has its own pros and cons) visit
the Excel Tips section (http://www.tushar- mehta.com/excel/tips/index.html) and scroll down to 'Iteration to animate a chart' -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I would like to be able to view my data set such that I can view the curve change over time instead of viewing for example 10 curves on one graph. I would like to be able to select the speed at which the curve is refreshed (new data set), and the direction (so I can run the curve forward and backward in time). In essence, I have monthly data that represents one curve. I would like to visually watch the curve change month by month instead of plotting one curve for each month, I see one graph with the curve in motion over my data set (time). |
#4
|
|||
|
|||
Thank you for your quick resonse, here is what I did:
YValue is the defined name for the offset as you suggested. I created a graph and typed "YValue" into the Data Range I entered an integer into the referenced cell in the offset formula. It worked great ... but I figured that I should be able to enter a new integer into the referenced cell and the graph would automatically change the curve ... it did not. I went into Chart, Source Data, and the Data Range was the actual range calculated by the last integer offset (Data!$D$1:$M$1) and NOT the name "YValue" that I originally entered. It seems that if "YValue" would remain the Source Data, then I could simply enter a new integer and it would automatically update the chart. Then I could create the macro as you have suggested. What am I doing wrong? "Jon Peltier" wrote: Randy - You set this up with defined names, such that the Y values is defined based on an integer value in another cell. Something like Name: YValues RefersTo: =Offset(Sheet1!$A$2:$A$12,0,Sheet1!$E$1) As the value in E1 increases, the range defined by the Offset is further and further to the right. Your chart is based on these YValues. Then you have a macro that moves forwards or backwards through the data by changing the value in E1 by a certain amount after a given delay. Shorter delays mean the curve changes more quickly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RandyBarrett wrote: I would like to be able to view my data set such that I can view the curve change over time instead of viewing for example 10 curves on one graph. I would like to be able to select the speed at which the curve is refreshed (new data set), and the direction (so I can run the curve forward and backward in time). In essence, I have monthly data that represents one curve. I would like to visually watch the curve change month by month instead of plotting one curve for each month, I see one graph with the curve in motion over my data set (time). |
#6
|
|||
|
|||
Jon,
After playing with the code it works beautifully!! Excellent suggestion and I thank you very much. Now I just need a good book on programming macros (I'm an old Fortran 77 guy). Thanks again. Randy "Jon Peltier" wrote: Randy - You set this up with defined names, such that the Y values is defined based on an integer value in another cell. Something like Name: YValues RefersTo: =Offset(Sheet1!$A$2:$A$12,0,Sheet1!$E$1) As the value in E1 increases, the range defined by the Offset is further and further to the right. Your chart is based on these YValues. Then you have a macro that moves forwards or backwards through the data by changing the value in E1 by a certain amount after a given delay. Shorter delays mean the curve changes more quickly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RandyBarrett wrote: I would like to be able to view my data set such that I can view the curve change over time instead of viewing for example 10 curves on one graph. I would like to be able to select the speed at which the curve is refreshed (new data set), and the direction (so I can run the curve forward and backward in time). In essence, I have monthly data that represents one curve. I would like to visually watch the curve change month by month instead of plotting one curve for each month, I see one graph with the curve in motion over my data set (time). |
#7
|
|||
|
|||
Randy -
Here are the books I use. Spend a half hour in a book store, and see which one(s) you like: http://peltiertech.com/Excel/xlbooks.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RandyBarrett wrote: Jon, After playing with the code it works beautifully!! Excellent suggestion and I thank you very much. Now I just need a good book on programming macros (I'm an old Fortran 77 guy). Thanks again. Randy "Jon Peltier" wrote: Randy - You set this up with defined names, such that the Y values is defined based on an integer value in another cell. Something like Name: YValues RefersTo: =Offset(Sheet1!$A$2:$A$12,0,Sheet1!$E$1) As the value in E1 increases, the range defined by the Offset is further and further to the right. Your chart is based on these YValues. Then you have a macro that moves forwards or backwards through the data by changing the value in E1 by a certain amount after a given delay. Shorter delays mean the curve changes more quickly. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ RandyBarrett wrote: I would like to be able to view my data set such that I can view the curve change over time instead of viewing for example 10 curves on one graph. I would like to be able to select the speed at which the curve is refreshed (new data set), and the direction (so I can run the curve forward and backward in time). In essence, I have monthly data that represents one curve. I would like to visually watch the curve change month by month instead of plotting one curve for each month, I see one graph with the curve in motion over my data set (time). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
time zone changes destroy all-day events | freelance9 | Calendar | 1 | February 1st, 2005 07:25 PM |
How can I stop the automatic time zone change of appointments. . | Caryll | Calendar | 0 | January 25th, 2005 04:41 PM |
Outlook 2003 - Change & edit default view for ALL folders - not just one at a time. | Jack Folliard | Setup, Installing & Configuration | 0 | November 11th, 2004 06:49 AM |
After change of daylight saving time all meetings one hour back! | dellborg | Calendar | 0 | November 8th, 2004 01:49 PM |
Help: Get movie to start only after some time and while advancing | Erik Berglund | Powerpoint | 1 | September 24th, 2004 02:21 PM |