Data Calisthenics : Gapminder Motion Chart - 5 ways to create these Motion Chart with your own data

Sometime back I wrote blog post on Gapminder.
It’s one of the most viewed post. Here is the link for the same:
Having used and worked with the motion chart, I found that many are fascinated by the insights a Motion Chart (Gapminder) throws out. 
Boring stats Can be transformed in to brilliant data dancing !
As I explore the Web world, I find many have tried various methods of presenting data the Gapminder way
Here I list out the possibilities I have come across.
Its a compilation of various methods of creating Motion Charts.
Each one is a master piece.. and efforts are worth a zillion claps....
The First: Use Google Docs
            The easiest way to make data dance.....
            Google Docs: MotionChart  : a Chart type in Google Docs
            Another link to explore is Quick Guide to Motion Chart
Here below is an example created by me  with Population and GDP of BRIC TM over a period of time.
The Second: Use Excel
            Making it possible in excel
Jon Peltier, author of the famous site http://peltiertech.com writes a post on how you can create motion charts in excel. Here is the link to his post
Jorge Camoes in his famous blog excelcharts. Here is his post
Anand from his brilliant blog http://www.s-anand.net/blog/
Here is the link to his post
The Third: Use Tableau
Andy Cotgreave in his Awesome Blog  Thedatastudio created Motion chart with all possible paraphernalia on Tableau
here below are the links to his posts
Here is the visualization he created on Tableau

The Fourth: Use Crystal Xcelsius
             http://www.ideas2evidence.com/showcase.html
             http://www.ideas2evidence.com/demos/CO2-demo.html

The Fifth : Use TrendCompass from Epic systems
          Trend compass is a commercial software from Epic systems.
          Trend compass uses the basic idea of showing five variables in a single graph
          (X,Y,Bubble size, Bubble Color and Time) as a motion chart.
The user interphase is quite intuitive and simple to create Visualizations. However, for the first time user, arranging data may be a challenge. The simple solution is to follow Trend Compass's instructions and their model of Excel to arrange data.
Trend Compass helps you present your business data from your own desktop without hassel of connecting to internet and hopping between presentation and web.
Here is a demo of Trendcompass form the website http://www.epicsyst.com/test/v2/mastercard_vs_visa/
You can download a demo version that works for 30 days....

For those who want to start from the basics , you can watch the video below from Steve



Last but not the least...

You can download Gapminder for desktop
Yet another great site for data is OECD- Factbook
Though You can not use these with your own data, You have enough and more to explore..
Now...Play..... 

2 comments:

  1. Thanks a lot for sharing this with all folks you really recognise what you are talking about! In this complex environment business need to present there company data in meaningful way.Sqiar (http://www.sqiar.com/solutions/technology/tableau/) which is in UK,provide services like Tableau and Data Warehousing etc .In these services sqiar experts convert company data into meaningful way.

    ReplyDelete