How would you Visualize World Education Ranking Data [Homework + Video]
Here is a charting challenge to begin your Christmas week. Recently Guardian’s Data Blog released World Education Rankings data and a sample visualization. Now your challenge is to make your chart visualizing World Education Rankings data.
You can see the chart I have constructed above. Read the rest of the post to find out how I made this chart and download the workbook.
Post your submissions using comments.
Show Months & Years in Charts without Cluttering
We make charts with date axis all the time. So, today we will learn how to set up axis settings in Excel so that Months & Years are shown neatly structured without cluttering your chart. See the example next to understand.
90% of you can see up to cell M26 & other findings [visualization]
Two weeks back I ran a poll asking you to tell me what is the last visible cell in your excel window. It was a casual poll. So I didn’t expect a lot of responses. But, boy I was wrong! 295 of you have responded at last count. This is so much more than what I expected.
As I said, the purpose of this poll is to make a visualization out of the poll responses. In this post you can see the chart(s) I made from this data & learn more.
Analyze Competition with Scatter Plots – A business chart example
Analyzing competition is one of the key aspects of running a business. In this article, learn how to use Excel’s scatter plots to understand competition, like shown aside.
The inspiration for this comes from a recent article on Asymco analyzing mobile handset market (Apple iPhone, Nokia etc.) and how it has changed since 2007.
Read the rest of the post to learn how to create this type of chart in excel. Also, you can download the chart template. Go ahead.
Thanks half a million… (and 2 excel tips)
I have a happy news to share with you!!! For the first time since starting this website, we got 500,000 + page views in the month of September 2010. Half-a-million! Thank you so much. To put this in context, in Sept 2009, we got 245,000 views. Traffic grew by more than 100% in last 12 […]
August 2010 – Best Month Ever (and 2 charting tips inside)
Time to stop everything we do and celebrate, for, our little community at chandoo.org had the most fantastic, awesome month ever.
That is right. August 2010 has been the best month since I started chandoo.org. We have broken a majority of previous records in terms of conversations, connections, content and revenues.
In August, we had 17 posts, with 604 comments. We had 178,000 visitors reading 453,000 pages. Our RSS subscriber base grew to 11,917 (it was 5738 an year ago). August has been the best month in-terms of revenues too. We sold highest number of project management templates & excel formula e-books since launch. We had a stellar launch for wedding planner with 22 customers.
Read rest of this post to find statistics about chandoo.org and get 2 charting tips.
5 Rules for Making Better Charts (and one fun chart)
Jeff Weir, an alert reader of this blog points me this chart showcasing voice-over artist’s for various Simpson’s characters. I am a hard-core Simpon’s fan, so I naturally wasted quarter-hour looking at the chart. That is when I realize this chart is not only fun, it also teaches 5 valuable lessons on making better charts. Read the rest of this post to find out the five rules.