[wynand]

Jon Peltier recently posted an article called "Gas Price Interactive Time
Series" on his blog. Can anyone please explain how the animation works?

[Jon Peltier]

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?

[wynand]

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?

[Jon Peltier]

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?

[wynand]

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

[paolo fibra]

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: