Animated chart

W

wynand

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

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
 
W

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
 
J

Jon Peltier

I don't know about those actions. I didn't click inside the chart while the
animation was running.

- Jon
 
W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top