Visualizing data is relatively easy to do these days considering the wide variety of tools at our disposal. Visual.ly, 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.
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.
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
Thanks for information.Posted by whazzupp on 09/05 at 08:03 PM
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 defaultsPosted by Printusher on 09/28 at 03:47 AM
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
You can also visit this website http://delhielections2013.in/Posted by Mehul on 10/11 at 10:13 AM
I love this website http://traveljee.com/india/top-ancient-bridges-india/Posted by John on 10/11 at 10:15 AM
I love my own website which is http://loksabhaelections2014.org/role-of-aam-aadmi-party-in-upcoming-general-elections-of-india-2014/204568/Posted by Nihal on 10/11 at 10:17 AM
I am student of Calvin. http://www.diwali2013.org/facebook-status-updates-diwali-2013-timeline-cover/Posted by Yasmin on 10/11 at 10:28 AM
Breaking defaults is article best. http://2014.co.in/2014-indian-public-holidays-complete-all-list-details/Posted by Chank Pandey on 10/11 at 10:29 AM
I think all is right. http://publicholidays2014.blogspot.com/2013/05/2014-japan-public-holidays-list.htmlPosted by Yun Chang on 10/11 at 10:30 AM
- Posted by Sifet on 10/11 at 10:34 AM
Visualization is the most important concept. http://2013-diwali.blogspot.com/2013/10/happy-diwali-2013-facebook-status-updates-for-facebook-friends.htmlPosted by Jayesh on 10/11 at 10:35 AM
I am big fan of this blog. http://www.beautyjee.com/2013/10/manasi-moghe-will-represent-india-at.htmlPosted by Mansi on 10/11 at 10:37 AM
Great statisticsPosted by Elchim blow dryer on 01/07 at 07:10 PM
Thank you for sharing such info!Posted by Ezy Va on 01/09 at 11:17 PM
I wish to see that stat on 2013.
http://ezyva.com/Posted by Wod on 01/09 at 11:18 PM
Thanks for all the data, looking for morePosted by Click here on 01/12 at 08:55 AM
Previous entry: Spending Ourselves Out of Recession?