Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Animated chart
Jon Peltier recently posted an article called "Gas Price Interactive Time
Series" on his blog. Can anyone please explain how the animation works? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Animated chart
The chart plots the data in the first two rows of the data sheet.
The scroll bar under the chart is linked to cell A1 in the data sheet. This corresponds to the row of the data list which is listed in row 2 of the data sheet and plotted in the chart. The first row of the data sheet contains series names, which do not change. The second row extracts the values from the proper row using this formula: cell B2: =INDEX(B$9:B$808,$A$1) If A1's value is 1, B2 takes the 1st value from the data range B9:B808. If A1's value is 10, B2 takes the 10th value. The scrollbar directly changes the value in cell A1. The go to beginning and go to end buttons change A1 to 1 and 800 respectively. The forward and reverse buttons start VBA routines that add 1 to or subtract 1 from the value in A1 in each iteration. The pause button changes the value of a Boolean to true, and when the incrementing code is running, it tests this value: when it becomes true, the code stops incrementing. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... Jon Peltier recently posted an article called "Gas Price Interactive Time Series" on his blog. Can anyone please explain how the animation works? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Animated chart
Thanks Jon, but I am referring to your download workbook example with this
article. Clicking outside the chart or inside the chart animates or reanimates (for a lack of a better word) the chart. I cannot find any link to this acion in vba or any other control for this "Jon Peltier" wrote: The chart plots the data in the first two rows of the data sheet. The scroll bar under the chart is linked to cell A1 in the data sheet. This corresponds to the row of the data list which is listed in row 2 of the data sheet and plotted in the chart. The first row of the data sheet contains series names, which do not change. The second row extracts the values from the proper row using this formula: cell B2: =INDEX(B$9:B$808,$A$1) If A1's value is 1, B2 takes the 1st value from the data range B9:B808. If A1's value is 10, B2 takes the 10th value. The scrollbar directly changes the value in cell A1. The go to beginning and go to end buttons change A1 to 1 and 800 respectively. The forward and reverse buttons start VBA routines that add 1 to or subtract 1 from the value in A1 in each iteration. The pause button changes the value of a Boolean to true, and when the incrementing code is running, it tests this value: when it becomes true, the code stops incrementing. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... Jon Peltier recently posted an article called "Gas Price Interactive Time Series" on his blog. Can anyone please explain how the animation works? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Animated chart
I don't know about those actions. I didn't click inside the chart while the
animation was running. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... Thanks Jon, but I am referring to your download workbook example with this article. Clicking outside the chart or inside the chart animates or reanimates (for a lack of a better word) the chart. I cannot find any link to this acion in vba or any other control for this "Jon Peltier" wrote: The chart plots the data in the first two rows of the data sheet. The scroll bar under the chart is linked to cell A1 in the data sheet. This corresponds to the row of the data list which is listed in row 2 of the data sheet and plotted in the chart. The first row of the data sheet contains series names, which do not change. The second row extracts the values from the proper row using this formula: cell B2: =INDEX(B$9:B$808,$A$1) If A1's value is 1, B2 takes the 1st value from the data range B9:B808. If A1's value is 10, B2 takes the 10th value. The scrollbar directly changes the value in cell A1. The go to beginning and go to end buttons change A1 to 1 and 800 respectively. The forward and reverse buttons start VBA routines that add 1 to or subtract 1 from the value in A1 in each iteration. The pause button changes the value of a Boolean to true, and when the incrementing code is running, it tests this value: when it becomes true, the code stops incrementing. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... Jon Peltier recently posted an article called "Gas Price Interactive Time Series" on his blog. Can anyone please explain how the animation works? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Animated chart
Jon, what I am refering to might not be animation. Clicking on those places
(in the chart or close to the chart) in the sheet I mentioned "refreshes" the chart. This looks like animation, but is probaly not as I cannot find any link to this action. This I found in your dowload workobook. I am using Excel 03. "Jon Peltier" wrote: I don't know about those actions. I didn't click inside the chart while the animation was running. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... Thanks Jon, but I am referring to your download workbook example with this article. Clicking outside the chart or inside the chart animates or reanimates (for a lack of a better word) the chart. I cannot find any link to this acion in vba or any other control for this |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Animated chart
This is a good way for create aniamted chert with excel:
http://www.labdg.com/excel/excel_chart_animation.htm <a href="http://www.labdg.com/excel/excel_chart_animation.htm"http://www.labdg.com/excel/excel_chart_animation.htm</a On Friday, August 22, 2008 1:15 AM wynan wrote: Jon Peltier recently posted an article called "Gas Price Interactive Time Series" on his blog. Can anyone please explain how the animation works? On Friday, August 22, 2008 8:46 AM Jon Peltier wrote: The chart plots the data in the first two rows of the data sheet. The scroll bar under the chart is linked to cell A1 in the data sheet. This corresponds to the row of the data list which is listed in row 2 of the data sheet and plotted in the chart. The first row of the data sheet contains series names, which do not change. The second row extracts the values from the proper row using this formula: cell B2: =INDEX(B$9:B$808,$A$1) If A1's value is 1, B2 takes the 1st value from the data range B9:B808. If A1's value is 10, B2 takes the 10th value. The scrollbar directly changes the value in cell A1. The go to beginning and go to end buttons change A1 to 1 and 800 respectively. The forward and reverse buttons start VBA routines that add 1 to or subtract 1 from the value in A1 in each iteration. The pause button changes the value of a Boolean to true, and when the incrementing code is running, it tests this value: when it becomes true, the code stops incrementing. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... On Friday, August 22, 2008 9:48 AM wynan wrote: Thanks Jon, but I am referring to your download workbook example with this article. Clicking outside the chart or inside the chart animates or reanimates (for a lack of a better word) the chart. I cannot find any link to this acion in vba or any other control for this "Jon Peltier" wrote: On Friday, August 22, 2008 4:56 PM Jon Peltier wrote: I don't know about those actions. I didn't click inside the chart while the animation was running. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "wynand" wrote in message ... On Monday, August 25, 2008 1:38 AM wynan wrote: Jon, what I am refering to might not be animation. Clicking on those places (in the chart or close to the chart) in the sheet I mentioned "refreshes" the chart. This looks like animation, but is probaly not as I cannot find any link to this action. This I found in your dowload workobook. I am using Excel 03. "Jon Peltier" wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
animated / motion / chart Excel | Charts and Charting in Excel | |||
animated gif won't play | Excel Discussion (Misc queries) | |||
Animated charts | Charts and Charting in Excel | |||
Animated bar Charts | Excel Discussion (Misc queries) | |||
Chart Animated Sine Wave | Charts and Charting in Excel |