All articles in 'Charts and Graphs' Category

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.

Dynamic charts are like my favorite food, Mangoes. They tempt, tease and taste awesomely. In this post, we are going to learn how to create a dynamic chart using check boxes and formulas as shown in the animation aside. Are you ready for some excel chart cooking?

You can also download a FREE Dynamic chart template from the post. So go ahead and make your boss drool.

Here is an interesting charting problem we come across once in a while. We have a lot of small numbers and a few very large numbers. How do we effectively plot all of them in a chart?

Now, how do you go about making a chart?

I don’t remember when was the last time both of us (Jo and I) were this excited. And the reason?

Nakshatra and Nishanth have started taking their first steps last week !!!

It is such a joy watching them take one step at a time. Aah, the beauty of parenting

So I asked myself, “What is a good way to celebrate this without looking like a super-excited dad?” and I got my answer in 72 milli-seconds.

I have created 10 short (<10 min) videos helping you to take baby steps in Excel world. Each video introduces you to one new functionality of Excel and shows you some nice examples.

Before jumping straight in to the videos, I want to share a short clip (30 seconds) of our kids taking their baby steps.

Last week I announced Reader Awesomeness Week to celebrate the passion, attitude and knowledge of our little community here. I got 9 interesting and beautiful entries from our readers. In this post you can see 9 tips & downloads submitted by our readers. These include a project management template, a macro to remove blanks, a technique to make Google Earth maps using Excel and several other interesting tips & tricks.

Go ahead and read them, download attached workbooks and become awesome in Excel.

As part of our Reader Awesomeness Week, Francis shares with us a travel site dashboard he made for his company. Francis took just two days to prepare this awesome dashboard which uses concepts like bullet charts, sortable KPI grid, Date based filtering, dynamic charts and more. I was really moved by Francis’ gesture in sharing his work with us, so much that, I did a video review of his work. You can see it in the embedded youtube video to the left.

Read the rest of the article to know how this dashboard is made and get a copy of the file.

Faheem (@FaheemH) from Denmark sent me this beautiful infographic depicting various facts about Immigrants in Denmark.
Immigrants in Denmark – Excel Infographic:

[view high res]
How is this Info-graphic made?
Faheem used a variety of tricks to create this infographic. Some of the key ideas are,

Using text boxes and drawing shapes
Using bar charts (with both negative and positive values)
Using [...]

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.

Keeping track of your expenses is one of the fundamentals of living good life. So I asked you to prepare a personal expense tracker as part of our 10,000 RSS Subscriber Milestone contest. I have received 7 excellent entries in this contest, each capable of making expense tracking a breeze while providing good analytics of [...]

This article is written by Alex Kerin from Data Driven Consulting.

“When expensive dashboard software doesn’t work, do it with Excel” stated Stephen Few back in 2006. This was before the release of Tableau, and some of the other solutions now available for visualizing your data, but Excel remains a great choice for creating dashboards when you extend [...]

On Firday, we proposed a new chart for showing project plans. I chose an ugly name for it and called it Gantt Box Chart.
Essentially, a gantt box chart is what you get when a gantt chart and box plot go to a bar, get drunk and decide to make out. It shows the project [...]

Traditional project plans use Gantt Charts to depict the plan. While gantt charts work great and provide instant picture of overall plan, they fail to communicate the uncertainty in the plan. In most real world projects, the plans always change. Most of the management energy is spent on controlling and communicating about this plan uncertainty. This is where a project plan like gantt box chart can help. This chart (as shown above) clearly shows the variance in end dates of project tasks thus giving a clear picture of uncertainty in the plan. Read more to find out how this chart can be used in project management.

Hui, one of our in-house excel ninjas at Chandoo.org Forums, has asked an interesting question.
Microsoft is already planning the next version of Excel and is looking for our feedback into what extra chart types it should offer/include. [more]
It is an interesting question, so lets have a poll.
What new chart types you prefer to see next [...]

Today FIFA World-cup 2010 is beginning. For the next 30 days or so, no matter where you go, you are bound to hear about soccer, world cup, teams, points, goals and what not.
As a tribute to this beautiful and lovely sport, I want to showcase some really awesome excel spreadsheets that are designed to track [...]

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 [...]