today, when reading on my LinkIn feed I found an animation from a series of global temparature points per country since 1880 and I was stunned by the graphics. The animation was created by a Finnish meteo scientist, Annti Lipponen, and I felt immediately challenged to see if Ii could re-create it in Excel. (link to the linkedin feed: https://www.flickr.com/photos/150411108@N06/35471910724/in/photostream/)
At first I thought about a sunburst chart but that is definitely not the answer. More like a filled radar plot. The animation could be done with VBA.
But I got stuck! First in finding the used data (no luck with that) but most important with the chart itself. Even with a dummy set (all countries per continent, 1 year of fake temperature data) I'm not getting any closer. And I've done my share of custom graphs like vertical waterfalls with subtotals and the usual gannt charts with progress bars..... I even understand the Wall Mart animation from Jorge Camoes his book "Data at Work". So it's not like I don't know how to combine datasets to a chart.
Any thoughts? Or can I find the answer somewhere else on the forum....
At first I thought about a sunburst chart but that is definitely not the answer. More like a filled radar plot. The animation could be done with VBA.
But I got stuck! First in finding the used data (no luck with that) but most important with the chart itself. Even with a dummy set (all countries per continent, 1 year of fake temperature data) I'm not getting any closer. And I've done my share of custom graphs like vertical waterfalls with subtotals and the usual gannt charts with progress bars..... I even understand the Wall Mart animation from Jorge Camoes his book "Data at Work". So it's not like I don't know how to combine datasets to a chart.
Any thoughts? Or can I find the answer somewhere else on the forum....