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

Rakesh Mohan on Getting the Attention of Your Audiences

Rakesh Mohan on Getting the Attention of Your Audiences

In this photo, everyone, including the baby, appears to be paying attention to the person sitting in the center. Rakesh took this photo in 2007 when he visited his village in India where he spent first two years of his life.  This was his first…

Continue reading →

Letting Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Letting Spreadsheets Do the Heavy Lifting: Number Formatting Tips

I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely on Excel’s default settings when you can easily format your spreadsheet to fit your exact preferences? There are numerous formatting adjustments you can make to…

Continue reading →

Adjusting Your Bar Chart’s Spacing in Excel

Adjusting Your Bar Chart’s Spacing in Excel

Let’s pretend you’re graphing age distributions for a given county. You carefully formatted your histogram: you removed the border, lightened the grid lines, wrote a descriptive title and subtitle, selected customized RGB color codes, and called attention to a section of the graph with the saturated action…

Continue reading →

Introducing the Essentials, a Chart Choosing Tool

Introducing the Essentials, a Chart Choosing Tool

Last summer, my husband was traveling for work and I had the house to myself for an entire week. I could’ve binge-watched Sex and the City or eaten crumbly crackers in bed, his one-and-only marriage deal breaker. Instead, I designed my own chart taxonomy (while…

Continue reading →

Heat Table How-To in Excel

Heat Table How-To in Excel

Just because I adore graphs doesn’t mean that I shun data tables. I insert the occasional table inside the body of my report, and each report’s appendices are full of tables, tables, and more tables. When creating traditional tables, I follow the Dark Horse Analytics guide….

Continue reading →

Six Alternatives to the Clustered Bar Chart

Six Alternatives to the Clustered Bar Chart

We can all agree that 3-d exploding pie charts are pretty rotten. My vote for worst chart? The clustered bar chart. I see clustered bar charts everywhere. E-V-E-R-Y-W-H-E-R-E. On pages 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10 of reports. In slides 1, 2, 3,…

Continue reading →

Traditional Table for the Report, Heat Table for the Presentation

Traditional Table for the Report, Heat Table for the Presentation

Back in college I was so obsessed with data that I voluntarily wrote a 66-page thesis about adolescent development. The “Before” Version: Data Table in the Research Report My paper was filled with these: A major piece in the data visualization puzzle is understanding your…

Continue reading →

Visualization in 2015: New Year’s Resolutions to Further Your Data Development

Visualization in 2015: New Year’s Resolutions to Further Your Data Development

What do you foresee happening in the visualization field this year? Promising changes are underway. You can move the field forward and further your own professional development at the same time. Repeat these mantras with me. This year, I resolve to: …commit to easier-to-read layouts. The…

Continue reading →

Developing a One-Page Annual Report

Developing a One-Page Annual Report

At a recent Board of Directors meeting: “I think I’ll design a one-page annual report for the Washington Evaluators!” Draft 1 At the meeting: “Which metrics would we include? Maybe stats about the number of members, number of events held, brown bag topics….?” Look closely, can…

Continue reading →

The Best Visualization Tool of All Time

The Best Visualization Tool of All Time

It’s your brain. A few of the million+ decisions your software program can’t make for you: 10. Which chart is best for your data. Yes, I’m well aware of Excel’s Suggested Charts feature. No, don’t even think about it. There’s no substitute for your critical thinking…

Continue reading →

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