Shocking Revelation: Excel 2007 is Useless

Excel 2007 is useless. This was a shocking revelation when I tried to create the charts for last post (Chart Design: Abortion Ratios 1980-2003). It was my first serious attempt at using Excel 2007. I failed miserably and gave up. I had to do everything in Excel 2003 and then open the file in Excel … Read more

Chart Design: Abortion Ratios 1980-2003

Source: U.S. Census Bureau (original Excel file). The abortion ratio is defined by the number of abortions per 1,000 abortions and live births. (Click to enlarge) Notes: 1. We know that information visualization is all about pattern detection. But often our design choices hide relevant patterns behind the obvious one(s). Take this panel, for instance. … Read more

Chart redesign: California majority party by county

Nathan asks us Can You Improve this Mediocre Statistical Graphic? Since there are only two series (two parties) with a obvious mirror effect, I would say it doesn’t make sense (from a chart economy point of view) to display both series. And since the 50% mark is relevant in election results, why shouldn’t we just … Read more

Why can't bloggers-about-blogging do basic charts?

I follow some of the top blogs-about-blogging and they often come up with advices that I can relate to when thinking of information visualization: simplicity, consistency, go to the point, remove clutter, tell a story… Problem is, bloggers about blogging fail to follow their own advice when they attempt to graphically display the results of … Read more

Learn Excel, Spend More Time with the Kids

I love to spend time playing with my three-years old twins, and I wholeheartedly want to create for them the memories of a happy childhood. This is something that I can’t delegate, and if I don’t have the time, I’ll have to find it. They will not wait to grow up. Stupid time wasting at … Read more

The consultant’s chart: a dilemma

How do you sell your outrageously expensive consulting services? Simple, just add a chart… Not every chart will do, of course. Let me outline some basic design rules of what I call a “consulting chart”: It shouldn’t be recognizable as a standard chart that you could create in Excel; It shouldn’t use popular eye-catching design … Read more