Learn how to use the “Value From Cells” option in Microsoft Excel.
Continue reading
About three years ago, I created a Tile Grid Waffle Chart Map for the African continent. At the time, I played around with creating a version for the United States, but never got around to using it. Recent work gave…
Continue reading
For the past few years, I’ve been working with teams of Interdisciplinary Research Leaders as they develop their research projects. Most teams are made up of three people and consist of researchers and community partners, including community organizers and advocates….
Continue reading
As you probably know, Excel does not have a native image-exporting feature, so it requires a separate process to create a high resolution, standalone Excel chart. Many people create standalone graphs by taking screenshots of their Excel window, but screenshots…
Continue reading
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
I really, really like this “radial map” (my name) the Guardian published in 2012 and then updated in 2015. The visualization shows seven different types of gay rights in all 50 US states plus Washington, DC. Each ring represents a…
Continue reading
Like color, choosing a font can be a difficult decision for even the most seasoned designer. As one who is definitely not a typographer, I will usually seek help from others to guide my font selection. Given that I’m usually…
Continue reading
It almost goes without saying, but tables are a way to visualize data. Tables of regression results are a common type of table researchers create. But they can be frustrating to create well—point estimates, standard errors, asterisks, variable names, column…
Continue reading
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
LGBTQ Rainbow Bar Chart
$11.00 – $16.50
Excel Histograms with Words Template
$3.00
Excel Clocks Template
$3.00