Tutorials

in On..., Tutorials

On…Fireworks in Excel

The “On…” series is a collection of short blog posts relating to data visualization, economics, presentation skills, or data communication. In each, I discuss an issue, concept, or idea that I have not fully developed, a work in progress, or…

Continue reading
in Tutorials

Arc-Dot Chart in Excel

A couple of weeks ago, I started making the graphs in the Financial Times’ Visual Vocabulary in Microsoft Excel. Based on the Graphic Continuum work I’ve done with Severino Ribecca, the FT’s Visual Vocabulary contains about 70 graphs with a…

Continue reading
in Tutorials

A Tile Grid Map of DC

My affinity for tile grid maps is well documented. I think there a nice alternative to the standard choropleth map and even though they introduce their own geographic distortions (such as South Carolina placed to the east of North Carolina),…

Continue reading
in Tutorials

Create a Gradient Plot in Excel

Communicating uncertainty is a difficult task. Many readers don’t fully appreciate or understand uncertainty, what it means, and where it comes from. A similar case can be made for visualizing distributions. I’ve heard many complaints about the good ol’ box-and-whisker…

Continue reading
in Tutorials

The Raincloud Plot

A few weeks ago, I published an Excel tutorial on how to create the ill-named “box-and-whisker-and-scatterplot chart.” In response, Len Kiefer pointed me to a post on Maarten Lambrecht’s cool new project Xenographics that was essentially the same chart type, just…

Continue reading
Close