Tag archive for Excel 2016

Transforming a Table: Four Charts and Four Different Stories

Transforming a Table: Four Charts and Four Different Stories

A few weeks ago I gave the keynote speech at the Alabama Power Foundation’s Elevate conference for several hundred of their grantees and partners. What a day! As part of the most-practical-keynote-you’ve-ever-heard emphasis, we included makeovers from the grantees’ real projects. In case it’s useful…

Continue reading →

Pie Chart Makeover: Quarterly Breakouts by Gender

Pie Chart Makeover: Quarterly Breakouts by Gender

A few weeks ago I was in Indianapolis with the juvenile detention alternatives initiative. This group wanted to graph: how many youth went to juvenile detention centers, by gender, and by quarter. Brainstorming There are a dozen ways to graph each dataset. For this data,…

Continue reading →

Sorting Your Bar Charts

Sorting Your Bar Charts

“Ann, my bar chart is upside down! Help!” You read my prior post about using horizontal bar charts for nominal variables like favorite fruits. My toddler is eating two! bananas a day so bananas are the winner in this fictional fruit contest. Our original table…

Continue reading →

Removing Redundancies from My Old Graphs

Removing Redundancies from My Old Graphs

This morning I keynoted a conference in Tallahassee. Data visualizers who critique others before critiquing themselves make me gag, so I opened my talk with a trip down memory lane. Check out this beauty from one of my earliest jobs. I’ve anonymized it but 99.9% of…

Continue reading →

How to Flip Your Bar Charts

How to Flip Your Bar Charts

“Ann, I read your latest post, and I accidentally made a horizontal bar chart when it should’ve been a vertical bar chart! Am I going to have to delete my graph and start from scratch?”   No way. Don’t delete a thing. That would be a huge…

Continue reading →

Page 1 of 2 1 2