I’ve done a handful of animations lately:

Gas Prices - Animated Bar Chart for Excel
Gas Prices - Animated Bar Chart for Excel 2
Gapminder for Excel
Rolling Wheel Animation

This example shows the position and path of a moving projectile which is launched at a given velocity and angle. The math is high school physics, with a little calculus [...]

In Chart Event to Highlight a Series, I showed how to use a chart legend plus chart events instead of a listbox, to select which series to highlight in a busy multi-series chart. That technique is useful, but it is not versatile: it is applicable only to a chart sheet that has the code in [...]

I’ve posted several times recently (for example, here, here, and here) showing examples that use a listbox to allow the user to highlight a series in a chart. Then I realized that the listbox requires an additional element which is not really integral to the chart. So I thought, why can’t I use a list [...]

In Watch the Rise of Gasoline Retail Prices, 1993 - 2008, Nathan shows an animated bar chart that traces the price of gasoline over the past 15 years. A number of readers responded with links to assorted time series.
I downloaded Nathan’s data workbook and duplicated Nathan’s animated bar chart in Excel in Gas Prices - [...]

We all have been awed and amazed by the Hans Rosling talk Debunking third-world myths with the best stats you’ve ever seen.

The software used by Professor Rosling is Gapminder. There are demos and links to numerous similar presentations on their web site.
I’ve made numerous animated charts in Excel, including Gas Prices - Animated Bar Chart [...]

In Gas Prices - Animated Bar Chart for Excel, I duplicated Nathan’s dynamic bar chart of gas prices in Excel.

It’s a pretty nice animation, but there is no sense of where the bar chart is along the date scale of the data. I made a small adjustment to the model above, drawing a small time [...]

In Watch the Rise of Gasoline Retail Prices, 1993 - 2008, Nathan shows an animated bar chart that traces the price of gasoline over the past 15 years. Nathan’s animated chart looks like this:

I downloaded his data workbook and went to work duplicating his chart in Excel.

In Interactive Multiple Line Chart I showed how to make an interactive chart that allows the user to select from among a number of series using a listbox, and the selected series is displayed in a chart.

A similar technique is described in Interactive Parallel Coordinates Chart on my web site, and I used this technique [...]

In the Microsoft charting newsgroup, SKP asked how to make a chart that he could easily change from one series to another. This post will detail the steps to make an interactive chart that allows the user to select from among a number of series using a listbox, and the selected series is displayed in [...]

In Chart Design: Abortion Ratios 1980-2003 Jorge Camoes shows a nice panel chart of Abortion Ratios vs. Year (1980-2003) for different age groups, taking US Census Bureau data. I reproduce a few panels of Jorge’s chart below; click on the chart to see his entire panel chart.

Jorge points out the downward trend in the curves [...]