Projects and experiments

This is a page where you can find examples of my public work that I find interesting for some reason. Most Excel examples are here because they are unusual as Excel charts. They also tend to reflect my ideas and experiments about the data and how to display it visually.

Beautiful But Terrible Population Pyramids

Stretching population pyramids to display 150 years of population change.

William Playfair, please meet Excel

Using Excel to recreate a 19th century landmark chart by William Playfair.

Excess mortality and Covid-19 deaths

Using a single chart, we can visualize the evolution of mortality in Portugal and its relationshiop with Covid-19 deaths.

Population distribution in Europe

Is it possible to visualize two million data points in Excel? It is, and it looks good!

Parts-of-a-whole: the fan chart

A false pie chart that puts proportions in perspective (it’s actually a scatterplot).