Ann's Blog Equipping you to collect, analyze, and visualize data

The Data Visualization Checklist, 2016 Edition

The Data Visualization Checklist, 2016 Edition

Back in 2014, we launched the Data Visualization Checklist. Today, we bring you the updated version! Download your revised Data Visualization Checklist. What’s included in the updated Data Visualization Checklist? Stephanie and I tweaked five items: Text size is hierarchical and readable Labels are used…

Continue reading →

Removing the Double Y Axis

Removing the Double Y Axis

My least favorite charts of all time include clustered bar charts, 3D exploding pie charts, and line charts with two y axes. By now, hopefully you know my style. I’m not just going to complain about a graph without offering an alternative. Sometimes we need…

Continue reading →

Saving Time and Energy with Pivot Tables

Saving Time and Energy with Pivot Tables

Pivot tables are the fastest, easiest way to make sense of your data, and they’re easier than you think. In this post, I’ll show you how to insert a pivot table and then drag and drop variables to find patterns in your spreadsheet. Step 1:…

Continue reading →

The Simplest Excel Hack You’ll See Today

The Simplest Excel Hack You’ll See Today

In my prior post, I sketched a few options for a performing arts organization’s fictional ticket sales data:   I intentionally separated the year-by-year bars from the total bar with a little extra space. I don’t want all the bars mushed together. Easy to sketch…

Continue reading →

How the Sketching Process Works

How the Sketching Process Works

I’m back from a brief blogging break! I’ve spent the past few months speaking and designing – mainly designing. The reports and slideshows I’ve consulted on are starting to be published and it’s been so rewarding to watch organizations’ drafts transform into well-articulated masterpieces.   A…

Continue reading →

Page 1 of 32 1 2 3 4 5 ... Last →