If you’re new here, you may want to subscribe to my RSS feed. Thanks for visiting!Chandoo and Robert over at the PHD blog have a nice a 4 post series of posts about Creating KPI Dashboards in Microsoft Excel.

Show only 10 items of a huge list, but give the user the chance to [...]

This Heatmap Table shows you the revenues and the discounts of a company over the course of one year per product group. The size of a bubble shows the revenue made in a particular month and the bubble color shows the discount rate given. The discount rate has been encoded as a range of green [...]

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 series in a large data set is very powerful. All lines in the data set are [...]

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

Igor Asselbergs was contemplating the value of round corners in design. Is it eye-candy? Or does it add value to the user experience? He comes to the conclusion that rounded corners clearly make a difference.

 
 
 
 
“On the left side, you see one surface divided by a line. On the right side your eye interprets [...]