Links I have found interesting and worthwhile
Creating KPI Dashboards in Microsoft Excel [Part 2 of 4] - Adding One Click Sort. This is part two of a four-part guest series by Robert on Chandoo’s Pointy-Haired Dilbert blog. This part of the series shows an elegant way to allow sorting by a user selected column in [...]

I compared stacked and clustered charts in Stacked vs. Clustered. Stacked charts seem like they’d be good at showing proportions making up whole quantities, but I showed that the stacks only clearly display the bottom item in the stack and the total stack.
To illustrate this shortcoming, Nicolas Bissantz shows us a stacked bar chart showing [...]

Stacked charts are commonly used to compare proportions within a whole. In this post I will concentrate on stacked and clustered vertical column charts, but the arguments hold true for horizontal bar charts, and to some extent for area charts. This table shows some make-believe sales figures for an imaginary company, by quarter and by [...]

This post presents a VBA procedure that extracts all data from a chart, and places it into a new worksheet. Why would you want to extract a chart’s data? Sometimes a chart gets its data from diverse sources, and you’d like to have the data in one place. You may receive a workbook that contains [...]

I learned from Tim Mayes in Office Labs Chart Advisor for Excel that Microsoft’s Office Labs has developed an add-in that advises you based on your data what chart type you should use. From the Office Labs Chart Advisor page:
Chart Advisor is a prototype that provides an alternate approach for creating charts in Excel 2007. [...]

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

Once in a while I’ll post a handful of useful links. Here are some I’ve come across recently that I found interesting or useful, or which have led to discussion on this and other blogs.
My Places on File Dialogs - Save a lot of time during the day by adding frequently accessed folders to the [...]

In Installing an Excel Add-In I described the protocol for installing an add-in in Excel. The protocol I described was valid for Excel 97 through 2003, but the change in user interface which came with Excel 2007 was accompanied by a more tortuous protocol. It’s not really more complicated once you get used to it, [...]

In Plot your data around the clock, Chandoo proposed a complicated bubble chart to show website traffic vs. time of day.

I thought it was daring of Chandoo to try such a unique treatment of the data, but I found the bubbles difficult to interpret, and it was distracting that I had to look from chart [...]