Tag archive for Microsoft Excel

Pie Chart Makeover: Revenue and Expenses

Pie Chart Makeover: Revenue and Expenses

A couple weeks ago I was in Birmingham with the Alabama Power Company’s grantees. We spent two days learning data visualization principles and producing makeovers of their graphs. Before One of the grantees was presenting their revenue and expenses data like this, in two pie…

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 →

The Simplification & Emphasis Approach to Editing Graphs

The Simplification & Emphasis Approach to Editing Graphs

I teach about data visualization a lot. And it basically comes down to two techniques: simplification and emphasis. Here’s a default graph with fictional data: First, simplify the graph. Remove the border. Remove the horizontal grid lines. Remove the vertical axis. Remove the legend. Remove…

Continue reading →

Sorting and Filtering Your Spreadsheets

Sorting and Filtering Your Spreadsheets

Have a list of words that need some alphabetizing? Have a list of numbers that you want to arrange from least to greatest or greatest to least? Rather than painstakingly rearranging your rows by hand, let Excel’s Sorting and Filtering features do the heavy lifting…

Continue reading →

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Have a spreadsheet full of employee contact information? Demographic data for people in your community? A list of classmates attending that upcoming reunion? Most of our spreadsheets contain peoples’ names at some point in the project lifecycle. Here are a few shortcuts for dealing with text…

Continue reading →

Page 1 of 2 1 2