Displaying visual landscapes: profiles and dashboards

Infographics vs. Data Visualization

People keep asking what the difference is between data visualization and infographics. Since I'm not completely satisfied with the available answers I thought I could return to the subject and write my own. First, you have to recognize  that you can't compare them because they are not at the same level. Things get much simpler if we assume that data visualization [...]

By | October 2nd, 2013|13 Chart types: profiles, Design|8 Comments

The Horizon Graph Is a Reorderable Matrix Too: Unemployment Rate 1976-2012

Here is the draft result of my little weekend project, making horizon graphs in Excel: I'm probably using too many color bands, but I like it! The horizon graph is a very compact way to display lots of data points and a shiny example of how to break the rules for a good cause. It was developed by Hannes Reijner [...]

By | June 11th, 2012|13 Chart types: profiles, Chart Types|8 Comments

Animation, Small Multiples or the Reorderable Matrix? Growth of Walmart, Excel Edition

In data visualization, animation is overrated. OK, it's an interesting option if you can see a clear pattern emerging when displaying data over time/space (and, thanks to animation, we were introduced to this communicator extraordinaire named Hans Rosling). It's fun to make an animated GIF like the one above, but you must see animation as a component of interaction. The [...]

By | June 7th, 2012|13 Chart types: profiles, Chart Types|9 Comments

Charts: Monthly Unemployment Rates by State 1976-2009

Here are two ways to display a relatively large dataset, montly unemployment rates by state since 1976. The first one, above, is perfect to see the overall patterns, the range from the lowest to the highest, the outliers and the slopes. An interactive version would allow the user to highlight specific series. A small-multiple version allows the user to focus [...]

Excel dashboards according to Charley "ExcelUser" Kyd

If you google for "Excel dashboards", 6 out of the first 10 results link to Charley Kyd's ExcelUser website or some of his affiliates. MrExcel calls Charley Kyd "the king of Excel dashboards". There is a good reason for that. Three years ago, Charley Kyd published an e-book, Dashboard Reporting with Excel, probably one of the first books discussing charts [...]