Cosmograph in Excel - World migration with bilateral flow chart

posted Sep 20, 2013, 8:46 AM by r   [ updated Aug 13, 2014, 2:33 AM ]
: What is this?
Freddy: Schwarzwalder Kirschtorte
Monster (OS): Mmm
Freddy: Oh, do you like it? I'm not partial to desserts myself, but this is excellent
Igor: Who are you talking to?
Freddy: To you. You just made a yummy sound, so I thought you liked the dessert
Igor: I didn't make a yummy sound. I just asked you what it was
Freddy: But you did, I just heard it
Igor: It wasn't me
Inga: It wasn't me
Freddy: Well now look here, if it wasn't you, and it wasn't you

Monster (OS): Mmm.

by The FrankensTeam

Initially I was inspired by Peoplemovin Carlo Zapponi's chart. He describe his work with these words:
"peoplemovin shows the flows of migrants as of 2010 through the use of open data (see Data Sources). The data are presented as a slopegraph that shows the connections between countries. The chart is split in two columns, the emigration countries on the left and the destination countries on the right. The thickness of the lines connecting the countries represents the amount of immigrated people."

It is a very nice job that I wanted to reproduce in Excel ...and I created a file but did not get a satisfactory result (if you want I can send the file) ... sometimes we have to know how to lose ... or maybe we just need to change strategy. It is what i did :-) i thought that I had to group the data. If I could not use the data so in detail perhaps I could show flows from one region to another. I downloaded Bilateral migration matrix 2010 file and worked a bit on it. I used the groupings regions as defined by The World Bank and in the end I used a flow chart inspired by Cosmograph Willard Cope Brinton's chart (published in the Chapter 8 - Flow Chart 1939 in his Graphic presentation).
Now the result is much more satisfying :-)
I used the mouse rollover technique (a small function VBA to be activated when opening the file) to highlight the flows, the chart is bilateral, you can select the region right or left and see migration flow to/from that the region selected.

I had to fix the formulas in values (where it was possible) to lighten the file ... and probably could do much lighter and without all of that data ... but it came out so and maybe will improve it later :-)

Click here to download the Excel file.

See also here:
Anatomy of an Excel chart - Cosmograph dynamic version
Talent traffic chart with chord diagram in Excel
Life Expectancy by Nathan Yau's chart with Excel
Edward Tufte's Slopegraphs in Excel

Sep 20, 2013, 8:46 AM