If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!This bumps chart shows you the English Premier League 2007 - 2008. It allows you to highlight and compare two teams by clicking a team in in the table or a line in the bumps charts.

Interactively highlighting a data [...]

In a recent post Jon presented a way to dynamically hover over the chart legend to highlight a data series. Jon’s method is very smart, as it really shows the capabilities of the event rich Excel chart programing model.  The downside of this approach is that it requires you do code some VBA and only [...]

This blog post is the first in a series of blog post that features the winners of the 2008 Excel dashboard competition.
“A dashboard is a visual display of the most important information needed to achieve one or more objectives; consolidated and arranged on a single screen so the information can be monitored at a glance.”
—Stephen [...]

Before we go and review the 2008 Excel Dashboard Competition Winners I have to make you familiar with  the Dashboard Squint Test.
Software usability experts and web designer use a quite effective way to assess the organization of a web page or a user interface, the so called Squint Test. You squint your eyes and make [...]

Jorge suggested in a recent post to Use Charts to Validate Your Tables. He used a data set of the US census bureau that had some incorrect data in it. Creating a simple line chart on the data set immediately revealed that there is one extreme outlier in the data set.

Here the announcement of the Excel Dashboard Boot Camp hosted by the two experts Jon Peltier and Mike Alexander:
Microsoft MVPs Jon Peltier (Peltier Technical Services) and Mike Alexander (DataPig Technologies) are joining together to bring you our first annual Excel Dashboard and Visualization Boot Camp!

The Internet has introduced us to the great idea of providing more detail with just a click using hyperlinks. Now our new, free Excel add-in lets you do just that in your Excel dashboard.
As Andreas mentioned last time, our new function - the ParamLink - is perfect for drilling into the detail of a dashboard. [...]

Every good discipline needs a missing link. Evolutionary biology had a missing link between humans and the ‘lower’ animals. Physics has a missing link between quantum mechanics and general relativity. The Information Visualization community discovered the Missing Link Between Information Visualization and Art.
Now we discovered the missing link in Excel Data Visualization.
As we can see [...]

In financial report we are constantly comparing the actual numbers with our projections using variances.
A quick reminder
Absolute variance = Actual – Budget
Relative variance in % = (Actual – Budget) / Budget
Doing this over a report of even 10 lines requires row by row number comparison, and is not something which can be easily & quickly [...]

Here the history of the Abortion data set
1) Jorge used some U.S. Census Bureau data (original Excel file) to visualize the abortion ratio as a small multiples chart,
2) In Small Multiples - Abortion Data 1980-2003, I have written about Jorge’s panel chart. I like the panel (small multiples) chart, but felt that it can be [...]