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

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" <(E-Mail Removed)> wrote in message
news:5A8B2E8E-B6B2-48AD-8EFB-(E-Mail Removed)...
> Jon Peltier recently posted an article called "Gas Price Interactive Time
> Series" on his blog. Can anyone please explain how the animation works?

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" <(E-Mail Removed)> wrote in message
> news:5A8B2E8E-B6B2-48AD-8EFB-(E-Mail Removed)...
> > Jon Peltier recently posted an article called "Gas Price Interactive Time
> > Series" on his blog. Can anyone please explain how the animation works?
>
>
>

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" <(E-Mail Removed)> wrote in message
news:ED9C3A60-2511-488E-9876-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:5A8B2E8E-B6B2-48AD-8EFB-(E-Mail Removed)...
>> > Jon Peltier recently posted an article called "Gas Price Interactive
>> > Time
>> > Series" on his blog. Can anyone please explain how the animation works?
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:ED9C3A60-2511-488E-9876-(E-Mail Removed)...
> > 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
> >
> >
> >