I have a challenge for you. The chart above displays the evolution of infant mortality rate in Portugal. The years in the x-axis are not labeled on purpose. In one of those years there was a left-wing revolution. Left-wingers say that a sharp decline in the infant death rate is one of the “conquests” of the revolution, while right-wingers say that the […]
In the beginning of the Greek debt crisis, Greek hairdressers became one of the symbols of a badly managed country (they could retire at 50 with full benefits). But there is more and more interesting things to say about them.
Take a look at inflation rates for hairdressing salons and personal grooming establishments in Greece. This is something that you […]
I am sure I’m missing something here, but I don’t understand why making bullet charts and boxplots have to be so overly complex in Excel. Instead of messing around with bars and scales and secondary axes, a 1D scatterplot can be used to make both charts. I’ve been using this (obvious?) solution for a long time. I’m sure it […]
A few weeks ago, I needed a classification of chart types for my book, and reinventing the wheel was the last thing I wanted to do. I started with Andrew’s classification and the Juice Analytics version. It’s a good starting point, but I couldn’t fit it into my work, so I decided to design my own classification (it’s always nice […]
Time Magazine published a very boring combo dual-axes chart with a broken scale. Most of the time these charts beg for a connected scatterplot, so I made the one above. The original chart was something like this: I’m sorry, Time mag, but my chart tells hands down a much more interesting story. [UPDATE] Made a new, annotated version.
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 […]
Pies charts are fun to use, but it’s almost impossible for grown-ups to find a good reason for using them at work. So your first, safe-for-work choice is a bar chart. The boring bar chart.
I don’t like bar charts. There, I said it.
This is a little rant about bar charts, but also about the Eurostat. One of my first […]
I’m sure you’re familiar with the Walmart growth map. A basic visualization looks like this:
Obviously this has a lot of potential for a more design-oriented approach, and there are many examples online. Here is the map created by Nathan Yau at FlowingData:
I wanted to play with the data too, but from an Excel user perspective there isn’t much […]
There is not much of a story in the expected evolution of US population, according to the United Nations estimates and projections (1950-2100):
(You’ll see in a moment why there is a vertical line in 2005.) Things get a little more interesting if you split population by age groups. You can see that population is getting old at the top […]
If you want to make a choropleth/thematic map in Excel without programming perhaps conditional formatting is all you need. Here is how to do it:
Select a few hundred columns and rows;
Set width and height to 3 (more or less, depending on the resolutions you want);
Set font size to 1;
Place a map file over those cells and make it transparent […]