Easy Dot Plots in Excel

Easy Dot Plots in Excel

Last month I was at a Naomi Robbins’ workshop and she was pretty emphatic that dot plots are the better method of visualization, as compared to bar charts. The reason goes back to Cleveland’s early experiments on visual perception, which found that humans...
Making Back-to-Back Graphs in Excel

Making Back-to-Back Graphs in Excel

Let’s say we’re interested in comparing how two groups – oh, teachers and principals – responded to a survey. One way to visually display that comparison would be a bar graph, where each question had two bars, one for teachers and one for...