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

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 →

Will you present the data as-is, or tell a story?

Will you present the data as-is, or tell a story?

Viewer considerations are key: What type of information do your viewers need to see? What information do they already have? What information are they expecting? How many points in time should be included? Will you present aggregated or disaggregated findings? How long do you anticipate…

Continue reading →

More than Looking “Pretty” – Matching Graph Colors to Branding

More than Looking “Pretty” – Matching Graph Colors to Branding

Adding color to graphs is simultaneously the easiest and absolute hardest technique to nail. Color is about much, much more than simply making your graphs look pretty. When used well, color can enhance branding, guide viewers’ eyes to the most important pieces of the graph,…

Continue reading →

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