Basic to bomb column charts.

Screen Shot 2017-04-02 at 8.54.25 PM
The basic Excel column chart.
Let’s take a quick look at how a basic column chart in Excel can be turned into something you might want to look at.

  1. Enter your data into Excel
  2. Insert a column chart (if you’re basic, save and close here…)

Oh, good! You’re ready for more. Okay, here it goes:

  1. Get rid of that white space by decreasing the gap width.
  2. Remove the gridlines. They add unnecessary clutter for readers
  3. Trash the x-axis.
  4. …the y-axis, too!
  5. Add data labels (and for the love of all things, don’t leave them hanging in space – move them onto their respective bar).
  6. The title. I’m a fan of Stephanie Evergreen’s piece on this. Instead of a simple word or two, write a sentence that describes the dataset and LEFT justify it.
  7. Format! 10pt labels, 12pt title, non-default font and colors.

Bonus: Make everything a table. Sort them — highest to lowest (i.e. descending first), so readers don’t have to do the ordering themselves. 

Questions? Shoot me a message or tweet. 

Screen Shot 2017-04-02 at 8.53.49 PM
Our column chart gone bomb!

4 thoughts on “Basic to bomb column charts.”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s