All articles with 'scatter plot' Tag

4th of July Fireworks – an Excel animation for you

Published on Jul 4, 2014 in Charts and Graphs, VBA Macros

To all our readers & friends from USA,

I wish you a happy, fun & safe 4th of July.

For the last 4th of July (2013), we (Jo, kids & I) were in USA. We went to Washington DC to meet up a few friends for that weekend. And we had one of the most memorable evenings of our lives when we went to national mall area in the evening to watch beautifully choreographed fireworks. Kids really loved the amazing display of fire-crackers and enthusiasm.

While we all are back in India this time, it doesn’t mean we cant celebrate 4th of July. So I made some fireworks. In Excel of course.

Here is a little Excel animation I made for all of us.

4th of July Fireworks – Excel animation

First watch this quick demo (<15 secs)

Continue »

Is this a FIFA worldcup of late goals? Lets ask Excel

Published on Jun 25, 2014 in Charts and Graphs
Is this a FIFA worldcup of late goals? Lets ask Excel

Just like millions of viewers around the world, I too have been spending hours watching FIFA world cup football matches on TV. I don’t like spending hours watching TV. But when its FIFA world-cup time (which is once every 4 years), I am glued to the idiot box. Blame it on PaWaRa, my school teacher in 8th grade who instilled this passion.

So while watching the match day before yesterday (it was Holland vs. Chile), the commentator said, “This has been a world-cup of late goals” as both teams maintained 0-0 until 77 minute mark when Leroy Fer scored a goal for Holland.

That got me thinking,

Is this really a world-cup of late goals?

But I quickly brushed away the thought to focus on the match.

Later yesterday, I went looking and downloaded all the goal data for 2006, 2010 & 2014 FIFA world-cup matches (2014 data for first 36 matches).

Lets examine the hypothesis “2014 has been a world-cup of late goals”.

Continue »

Excel Dashboards – 49 dashboards to visualize US State to State migration trends

Hello everyone. Stop reading further and go fetch your helmet. Because what lies ahead is mind-blowingly awesome.

About a month and half ago, we held our annual dashboard contest. This time the theme is to visualize state to state migration in USA. You can find the contest data-set & details here.

We received 49 outstanding entries for this. Most of the entries are truly inspiring. They are loaded with powerful analysis, stunning visualizations, amazing display of Excel skill and design finesse. It took me almost 2 weeks to process the results and present them here.

49 Dashboards to visualize State to State Migration - Chandoo.orgExcel Dashboard Examples - Visualizing state to state migration trends - Chandoo.org

Click on the image to see the entries.

Continue »

Creating Triangular Plots using Excel

Published on Dec 9, 2013 in Charts and Graphs, Posts by Faseeh
Creating Triangular Plots using Excel

Triangular plot…! What is it?

Recently, a Chandoo.org forum member asked this,

‘I want to be able to make a graph that, in some aspects, looks like below, but I have no idea how to do it at all.’

After seeing it, I said to myself in Barney Stinson’s tone, ‘Challenge Accepted!

The final plot looks like above. Read on to learn how this is made.

Continue »

Chart for wall hygrometric physic (or how to create a chart with custom x axis intervals?)

Published on Apr 18, 2013 in Charts and Graphs
Chart for wall hygrometric physic (or how to create a chart with custom x axis intervals?)

Livio, one of our readers from Italy sent me this interesting problem in email.

I would like to prepare an xy linear graphic as representation of the variation of temperature trough a wall between two different bulk temperature i.e. outside and inside a house. This graphic should show the temperature gradient trough the wall thickness. The wall is normally made by different construction materials (different layers, as bricks, insulation, …..) and so the temperature change but not as a straight line with only one slope, instead as few lines with different slopes (see below figure) Calculations are not difficult, and also prepare the graphic also not difficult.

But, I am looking a beautiful solution for x-axis. X-axis should be divided not with constant interval, instead with different length between each sub-division exactly as the different thickness of the wall. This is a correct graphic, because you can show the correct slope of each straight line though each layer of the wall.

Continue »

KPI Dashboard – Revisited

Published on Mar 24, 2011 in Charts and Graphs
KPI Dashboard – Revisited

In 2008, I received an email from Robert Mundigl, which was the start of a life-long friendship. Robert asked me if he can teach us how to make KPI dashboards using Excel. I gladly said yes because I am always looking for new ways to use Excel.

The original KPI dashboards using Excel article was so popular. They still help around 12,000 people around the globe every month. Many of our regular readers and members have once started their journey on Chandoo.org from these articles.

In this article, we will revisit the dashboard and give it a fresh new spin using Excel 2007.

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 »

Analyze Competition with Scatter Plots – A business chart example

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

Continue »

Excel Links – Happy Birthday Edition

Published on Oct 20, 2010 in excel links

First some personal matters. Today I am celebrating my 28th birthday. The last one year has been very good for us. We have been very busy parenting 2 hilarious and naughty twins, I moved back to India, quit my job and started a company. My business became a mild success crossing $100k revenues in 12 […]

Continue »

Excel Links – Change in Posting Schedule Edition

Published on Jun 28, 2010 in excel links
Excel Links – Change in Posting Schedule Edition

Ok, this is bound to happen. After regularly writing for about 2 years now, I have decided to revise posting schedule on Chandoo.org. Usually I write 5 posts per week (about 21-22 per month). While I have not ran out of ideas yet (my notebook still has 94 different ideas yet to become posts), I […]

Continue »