All articles with 'visualization projects' Tag

Excel Teens are out to get you & Other findings from our Survey

Published on Feb 25, 2011 in Charts and Graphs
Excel Teens are out to get you & Other findings from our Survey

Our of curiosity and fun I asked you “how long have you been using Excel?”. I was overwhelmed by the response we got to this simple question. More than 437 people responded with their comments, stories and enthusiastic responses. Thank you so much.

It would taken me more time to make the charts and understand the data. But thanks to Hui, who volunteered to tabulate all the survey data in a simple CSV.

Shown above is a chart I came up with based on the data. Read the rest of the post to understand the survey results and view more charts. Also, you can download the excel workbooks and original data set to play.

Continue »

The Grammy Bump Chart in Excel

Published on Feb 22, 2011 in Charts and Graphs
The Grammy Bump Chart in Excel

The folks at Washington Post made an interesting chart to understand whether winning a Grammy award makes any difference to album sales. Go ahead and browse it if you have not already seen it. Go, I will wait.

Are you impressed?

I really liked this chart. This is what I liked about the chart,

  • It tells a story.
  • It is an ego chart. We would all instantly search for our favorite artists and learn about how Grammy award changed their album sales.
  • It is a simple chart. No clutter, no gaudy colors, just a bunch of lines and the story is out there.
  • It lets you play.

In fact, I liked the chart so much that I wanted to make it in Excel.. You can see a snapshot of what I came up with above. Read the rest of this article to learn more.

Continue »

How would you Visualize World Education Ranking Data [Homework + Video]

Published on Dec 20, 2010 in Charts and Graphs
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.

Continue »

An Excel Dashboard to Visualize 10,007 Comments [Dashboard Tutorial]

Published on Nov 24, 2010 in Charts and Graphs
An Excel Dashboard to Visualize 10,007 Comments [Dashboard Tutorial]

First some good news, On 21st November, 2010, our little blog received its 10,000th comment!

Thank you so much for making this happen.

Those of you reading chandoo.org for a while know my penchant for comments. I have learned a lot of excel tips & ideas just by reading the comments you posted on this blog. I think comments are one of the best parts of this blog. So, naturally, I wanted to celebrate this milestone, with something big & awesome.

My intention was to download all the 10,000+ comments and play with the data to come up with something outstanding, like a dashboard. It took me 2 days to conceptualize and create this beauty.

Continue »

90% of you can see up to cell M26 & other findings [visualization]

Published on Nov 12, 2010 in Charts and Graphs, Learn Excel
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.

Continue »

Football Betting Sheet Template

Published on Jun 9, 2010 in excel apps, Learn Excel
Football Betting Sheet Template

While I was working Denmark, there is one thing I noticed. Danes are one hell of football lovers. The football (soccer) enthusiasm is over the top when there is a match between Denmark and Sweden. A common practice in many offices is a football pool. This is how it works: When there is a match […]

Continue »

Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun]

Published on May 28, 2010 in Charts and Graphs
Official FIFA World-cup Soccer Balls since 1930 in an Excel Chart [Excel Fun]

The FIFA World-cup 2010 edition is around the corner. Like millions of people around the world, I too am an ardent fan of football. (although, I have played only one game of soccer in which I waited near opponents goal post as I was too lazy to run around. And when my team mates kicked […]

Continue »

Evolution of Privacy Policies on Facebook – a Panel Chart in Excel

Evolution of Privacy Policies on Facebook – a Panel Chart in Excel

Out of curiosity I took the data from Matt McKeon’s Privacy on Facebook chart and try to re-do the chart in Excel. I made a panel chart depicting how Facebook’s privacy policies have changed since 2005. You can see a bigger version of chart as well as get the download excel from the post. Read on…

Continue »

Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]

Published on Apr 9, 2010 in Charts and Graphs
Survey Results in Dot Plot Panel Chart [followup on Incell Panel Chart]

In a follow up to last week’s how to visualize survey data in excel, we will explore how you can create an incell dot plot panel chart. Please follow the links in the article to get more commentary and insights from established persona in the visualization world (including Stephen Few, Naomi, Jon etc.)

Continue »

Introducing Flag Project – A fun way to Learn Excel Charting

Published on Mar 8, 2010 in Charts and Graphs, Featured, India
Introducing Flag Project  – A fun way to Learn Excel Charting

I have a new community project for all the members of PHD. It is a simple yet intuitive challenge. Make your own country’s flag using Excel Charts. To start the project, I have made the Indian flag using a bar and pie chart. Go ahead and see the rest of this post to findout how this chart is made and then participate in the “flag project” by making your own country’s flag. All the best.

Continue »

Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster

Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster

Sachin Tendulkar is undoubtedly the best cricketers to play One Day International Cricket. He is a source of inspiration and joy for me and many others. So, naturally I was jumping with joy when I heard that he scored the highest ever runs in a single match on 24th of Feb. He scored 200 runs […]

Continue »

Best Month Ever (and a charting tip inside)

Published on Feb 5, 2010 in blogging, Charts and Graphs
Best Month Ever (and a charting tip inside)

Let us take a minute and bask in some glory, for, our little community at PHD had the most fantastic month ever. That is right, January 2010 is so far the best month since I started blogging. We have broken all sorts of previous records on content, conversations, connections, traffic and revenue. In January, we […]

Continue »

Flu Trends Chart in Excel [Yes, we can edition]

Published on Jan 22, 2010 in Charts and Graphs, Featured
Flu Trends Chart in Excel [Yes, we can edition]

Last week I have reviewed Google’s flu trends chart and told you that is it is very well made. Out of curiosity I made a similar chart in Excel. In this post, I am going to share the experience and results with you. Interested? Read on…

Continue »

A Brief History of Microsoft Excel – Timeline Visualization

A Brief History of Microsoft Excel – Timeline Visualization

Timeline charts are great for providing quick snapshots of historical events. And hardly a day goes by without some one making a cool visualization of a time line of this or that. Time lines are easy to read, present information in a logical manner and mostly fun.

So yesterday, I set out to mimic the iconic gadgets of all time in excel, just for fun. Then it strike me, why not make a visual time line of Microsoft Excel ? So I did that instead.

Continue »

Visualizing Search Terms on Travel Sites – Excel Dashboard

Published on Jan 19, 2009 in Charts and Graphs, Learn Excel
Visualizing Search Terms on Travel Sites –  Excel Dashboard

Microsoft excel bubble chart based Visualization to understand how various travel sites compete search terms

Continue »