Tag archive for Excel elbow grease

From Data Table to Small Multiples in Under Five Minutes

From Data Table to Small Multiples in Under Five Minutes

When social scientists like me have lots of data, we tend to put it in tables. There’s nothing wrong with tables. They contain infinite details within a finite and teeny space, and they give the reader freedom to draw his or her own conclusions about which details…

Continue reading →

The Dataviz Design Process: 7 Steps for Beginners

The Dataviz Design Process: 7 Steps for Beginners

Does data visualization leave you feeling like this? If so, this beginner-level post is for you! Data visualization requires two skillsets: technical skills to create visualizations in a software program and critical thinking skills to match your visualization to your audience’s information needs, numeracy level,…

Continue reading →

Nominal, Sequential, or Diverging? Simple Strategies for Improving Any Chart’s Colors

Nominal, Sequential, or Diverging? Simple Strategies for Improving Any Chart’s Colors

Colors can make or break a chart. Colors direct our eye movements, and therefore our brains and attention. It’s up to you: will you help or hinder your reader’s understanding? Here are some simple strategies for communicating clearly with chart color.   Strategy 1: Select…

Continue reading →

Dataviz Challenge #3: Alternate Solution by Paul Denninger

Dataviz Challenge #3: Alternate Solution by Paul Denninger

Note from Ann: Last week I shared a dataviz how-to guide. Paul Denninger has a great alternative solution to share! He uses hidden bars, also known in the Excel community as floating bars or white bars, to build “two” charts in one. Enjoy! Getting excel…

Continue reading →

Dataviz Challenge #3: How to Make a Side by Side Bar Chart in Excel

Dataviz Challenge #3: How to Make a Side by Side Bar Chart in Excel

Two weeks ago, I challenged readers to re-create the “after” version of a side by side bar chart. You can read the full post here. Congratulations to the 9 contestants! Click on the contestant’s name to see their chart. Regan Grandy Sara Vaca Alex Kadis…

Continue reading →

Page 1 of 2 1 2