I’ve written many blog posts and web pages on Dynamic Charts. See Dynamic Chart Review for a summary and Archive of ‘Dynamic Charts’ for an archive of the Dynamic Charts category on this blog. What they have in common is that they rely on you to define dynamic ranges in the worksheet, and then assign [...]

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

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

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