Tag archive for Excel 2016

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 →

Flipping Your Bar Charts

Flipping 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 waste…

Continue reading →

How to Place Labels Directly on Top of Your Line Graph

How to Place Labels Directly on Top of Your Line Graph

I recently discussed four options for labeling line graphs. A personal favorite is to place the labels directly on top of the data points, like this: There’s been a lot of interest in this labeling technique, so here’s your step-by-step tutorial!   First, set up…

Continue reading →