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?

  • $\begingroup$ 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. $\endgroup$ Commented Mar 23, 2017 at 9:49
  • $\begingroup$ @NeilSlater thanks for the suggestion! My map looks like this: blogs.position2.com/imguploads/2012/02/heat-map-us.jpg but it refers to Italy instead of US and I have labels over each region with the percentage. $\endgroup$ Commented Mar 23, 2017 at 10:24
  • $\begingroup$ 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? $\endgroup$ Commented Mar 23, 2017 at 11:19
  • $\begingroup$ Have a look at cycle plots. Though these are not ideal for spatial data. $\endgroup$ Commented May 22, 2017 at 16:37

1 Answer 1


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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.