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
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. Nick from Gas Brisbane.Posted by Nick from Brisbane on 06/25 at 12:43 AM
Hey Thanks for sharing this well described post. I always love to read which give all the needed information. and this post is of that kind.
GlobalCrazePosted by karan on 07/26 at 09:04 AM
I’ve spent some serious time with excel and am starting to become pretty proficient with it. However, to separate myself, I’m trying to develop the visual side of it. You really need to make things “pop” to grab the attention of a non-data nerd (unlike myself). This post was actually pretty helpful for that! :)Posted by Steve on 08/12 at 10:30 PM
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
I was expecting as a best guy using the applications names Excel, Photoshop, Illustrator, Tableau, Google Public Data, Many Data, and Stat Silk as just a few tools to visualize data but visualizing is the new more concept to my dictionary. I will do more search on it. The Printusher in US is also working for the cause of industries and people developmentsPosted by david on 09/28 at 03:50 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
I really loved this kind of data, very informtive
best hair dryer reviewsPosted by Best Hair Dryer Reviews on 12/10 at 12:24 PM
Previous entry: Spending Ourselves Out of Recession?