On my web site and blog, I have over a dozen pages that talk about dynamic charts. A partial list of these articles is provided at the end of this post.
I was asked to expand on one of my examples, specifically to show a dynamic chart with multiple dynamic series.
I made up the following data [...]

My colleague and fellow MVP Debra Dalgleish shows a dynamic chart approach that lets you Select Excel Chart Dates From a Drop Down List.

Debra has provided her usual comprehensive step-by-step instructions and an example workbook you can download. Her example was done in Excel 2007, but it works as well in previous versions.

An interactive dashboard by definition includes mechanisms for users to control aspects of the display. There are many ways to accomplish this. In Interactive Charting by Combo Box or Checkbox I wrote about using checkboxes to do this. That used a very simple example, which I will explore further in this article.
There are a couple of [...]

Jorge Camoes wrote in Focus + Context (a Bar Chart Is Not a Skyscraper) that tall bar charts are a waste of space. If you plan to show everything (say, all fifty state names), you may as well just use a table. I’m not sure I completely agree, but part of his point is that [...]

A few months ago in Gapminder for Excel I made a simplistic mockup of Hans Rosling’s Gapminder presentation Debunking third-world myths with the best stats you’ve ever seen in Excel. It was fairly simple, with a single bubble marching across a chart, interpolating between yearly data points as a simple timer-based VBA procedure incremented.
An astute [...]

Once again, I rely on Chandoo for inspiration for a charting tutorial. In Select and Show One Chart from Many he shows how to let a user choose which of several charts to show, in an interactive display. He uses data validation to enable the user to select from a finite list of charts, and [...]

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 Presidential Demographics, Part II, Robert Kosara has posted a very nice interactive infographic that allows you to answer a host of questions about US presidents:
Would McCain be the oldest US President? Would Obama be the youngest? Who was the youngest president? Were presidents younger in the past or older? What is the highest number [...]

A college science professor named Roger Blickensderfer wrote to me about an animation he was working on. He wanted to trace the path followed by a point on the rim of a rolling wheel. Roger had cobbled something together, and I fiddled with it, and it kind of worked. But I decided I wanted it [...]

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 – [...]