Blog

How to Make a Diverging Stacked Bar Chart in Excel

Sep 6th, 2013 / Data Visualization

Dataviz challenge #5 is complete. Here’s a list of the people that aced it along with step by step instructions on how to make a diverging stacked bar chart in Excel.

How to Make a Small Multiples Bar Chart in Excel

Jul 27th, 2013 / Data Visualization

Recently I challenged readers to re-create the “after” version of a small multiples bar chart. Here are the step by step instructions for how to make a small multiples bar chart in Excel.

How to Make a Bar Chart in Excel

Apr 25th, 2013 / Data Visualization

Two weeks ago, I challenged readers to re-create the “after” version of a basic bar chart. Here are the step by step instructions.

Pivot Tables: Your Tool for Exposing Miscreant Data

Mar 18th, 2013 / Data Analysis

Guest blogger Oz du Soleil, of DataScopic.net, shares how to use pivot tables as a way to expose miscreant data.

How to Make a Bubble Chart in Microsoft Excel

Mar 12th, 2013 / Data Visualization

Here’s a step-by-step guide to making circle charts (or “bubble” charts) in Microsoft Excel. You’ll learn how to use x, y, and z values to control the location and size of your circles.