On…Value From Cells
Learn how to use the “Value From Cells” option in Microsoft Excel.
Continue readingLearn how to use the “Value From Cells” option in Microsoft Excel.
Continue readingAbout 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 readingFor 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 readingAs 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 readingThe “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 readingI 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 readingLike 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 readingIt 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 readingA 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