Tag: <span>Microsoft Excel</span>

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

Feb 14th, 2017 / Data Visualization

Need to flip your bar chart with horizontal rows into a chart with vertical columns? Don’t delete your chart and start over from scratch. Instead, use this quick trick inside Microsoft Excel to rotate your bar charts.

How to Save Time and Energy by Analyzing Your Data with Pivot Tables in Microsoft Excel

Jul 19th, 2016 / Data Analysis

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.

How to Adjust Your Column Chart’s Spacing in Excel

Jul 5th, 2016 / Data Visualization

How do you adjust your column chart’s spacing in Excel? The secret strategy for nudging one of the columns over to the right: Add an empty column to your data table.

The Simplification & Emphasis Approach to Editing Graphs

Jan 26th, 2016 / Data Visualization

I teach about data visualization a lot. And it basically comes down to two techniques: simplification and emphasis. Here I’ll show you how to simplify a graph and then add emphasis.

How to Place Labels Directly Through Your Line Graph in Microsoft Excel

Jan 12th, 2016 / Data Visualization

I recently discussed four options for labeling line graphs. A personal favorite is to place the labels on top by going directly through the data points. There’s been a lot of interest in this so here’s the step by step tutorial.

How to Sort and Filter Your Data in Microsoft Excel

Dec 29th, 2015 / Data Analysis

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 for you.

Blog