Tag archive for Microsoft Excel - page 3

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 Rotate Horizontal Bar Charts into Vertical Column Charts (and Vice Versa)

How to Rotate Horizontal Bar Charts into Vertical Column Charts (and Vice Versa)

“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 →

Save Time and Energy with Pivot Tables

Save 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 →

How to Adjust Your Column Chart’s Spacing in Excel

How to Adjust Your Column Chart’s Spacing in Excel

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 →

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 →

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