Breaking Defaults

Visualizing data is relatively easy to do these days considering the wide variety of tools at our disposal., a great data viz blog, names Excel, Photoshop, Illustrator, Tableau, Google Public Data, Many Data, and Stat Silk as just a few tools to visualize data.

While some programs require a steeper learning curve to efficiently use, any user with a data set and some basic knowledge of Excel can produce a wide range of visualization types including bar graphs, pie charts, area charts, and scatterplots. Guest author to The Why Axis, Jon Schwabish, takes a look at a Bureau of Labor Statistics (BLS) visualization, done in Excel, for job openings in November 2012. While the visualization passes for use of appropriate chart type, it fails in its details. Because the BLS utilized default settings from Excel, the true story of the data is lost.

Schwabish takes us through minor changes, all done in Excel, to create a visualization that more effectively tells the story of job openings in November 2012. Schwabish explains the things he finds appealing about the visualization: sourcing, a left-aligned title, and values measured in thousands to name a few; however, the default coloring, automatic spacing, and ordering of the bars and industries are a few things to be improved upon.


His first of a series of changes is a quick sort on industry by descending values which helps to give more order to the graph. A change in colors helps to make the most recent data value stand out against the previous months while creating a more cohesive visualization.

First Change

Schwabish goes on to show more suggested changes to better the storytelling of Job Openings in November 2012. The take away here is not exclusive to Excel, but all data visualization programs. Simple design elements including descriptive text, color, font, and order are important to telling a story and, often times, the default settings for telling that story are not optimal.

Read the full blog post here and make sure to examine the transition from one version of the visualization to the next.

Posted by Traci Montgomery on 02/19 at 10:46 AM
  1. Damn you know your statistics. I only run a gas fitting business but have an interested in better visualizing data for good decision-making. Your general take away helped too. Thanks.

    Posted by Nick from Gas Brisbane  on  06/25  at  12:40 AM
  2. Thanks for information.

    Posted by whazzupp  on  09/05  at  08:03 PM
  3. I am currently making the videos for my campaign to Internet Marketing. So I was indeed of this type of thing to add text. I am now happy to see that i can be able to make my videos more aggressive by breaking defaults

    Posted by Printusher  on  09/28  at  03:47 AM
  4. What’s the matter? I’m not holding my breath. What an asinine notion, trust adobe to come up with this contentless idea. I’m not anti-Visualizing data…but I couldn’t eat a whole one.

    Posted by fotoshop yap  on  10/02  at  07:50 AM
  5. You can also visit this website

    Posted by Mehul  on  10/11  at  10:13 AM
  6. I love this website‎

    Posted by John  on  10/11  at  10:15 AM
  7. I love my own website which is

    Posted by Nihal  on  10/11  at  10:17 AM
  8. I am student of Calvin.

    Posted by Yasmin  on  10/11  at  10:28 AM
  9. Breaking defaults is article best.

    Posted by Chank Pandey  on  10/11  at  10:29 AM
  10. I think all is right.

    Posted by Yun Chang  on  10/11  at  10:30 AM
  11. I am big fan of Calvin.

    Posted by Sifet  on  10/11  at  10:34 AM
  12. Visualization is the most important concept.

    Posted by Jayesh  on  10/11  at  10:35 AM
  13. I am big fan of this blog.

    Posted by Mansi  on  10/11  at  10:37 AM
  14. Great statistics

    Posted by Elchim blow dryer  on  01/07  at  07:10 PM
  15. Thank you for sharing such info!

    Posted by Ezy Va  on  01/09  at  11:17 PM
  16. I wish to see that stat on 2013.

    Posted by Wod  on  01/09  at  11:18 PM
  17. Thanks for all the data, looking for more

    Posted by Click here  on  01/12  at  08:55 AM
Commenting is not available in this weblog entry.

<< Back to main