How to visualize trending over geographical area?


I would like to visualize how a percentage evolves in time over a geographical area.

In particular I have the percentage of products delivered in different regions and I want to show the weekly trend for each of the 21 regions. Currently I show a heatmap with the values of the current week and three line plots showing the trends of the 3 worst regions. I would like to show the full picture. Unluckily I can't use animations as I have to put the visualization on a static powerpoint.

I'm working with d3, sql and excel. Any idea?


Posted 2017-03-23T09:06:27.647

Reputation: 19

Given that the question is about visualisation, it could really help if you were to link a toy example of your current approach as an image (the text description is OK, but an image would be better). I or another user with enough rep could then make that an inline image in your question. Just be sure to use something it is OK to share - make up the data for instance, don't use your own project. – Neil Slater – 2017-03-23T09:49:30.443

@NeilSlater thanks for the suggestion! My map looks like this: but it refers to Italy instead of US and I have labels over each region with the percentage.

– cartoonheart91 – 2017-03-23T10:24:26.097

I meant an example of what you are currently doing. The heat map does not contain the line plots as you explain your approach, and everyone knows what a heat map is. The difficult thing is what you are asking about - how to show trends in the values associated with the map. Which is something you are doing - so should be relatively easy to produce a sharable image? – Neil Slater – 2017-03-23T11:19:13.760

Have a look at cycle plots. Though these are not ideal for spatial data. – Georg Heiler – 2017-05-22T16:37:25.977



Overly simple answer: "animate" this in PowerPoint by having one slide per time slice then advancing the slides quickly with the keyboard or set them to auto-advance.

If you have a little more flexibility outside PPT, there are free tools (e.g. Microsoft Power BI) where you could do a shaded map and have a time slider to make it more interactive.


Posted 2017-03-23T09:06:27.647

Reputation: 1 548