Thematic maps and other shape coloring in one line of code

Going back to the theme of ‘doing complicated things in one line of code’, here’s a mash up of cDataSet, Color Ramps, Mapping and various other things.

Lets say we want to create a thematic map in Excel from a simple set of data, in this example, the population of each country in the world, and apply a heatmap coloring. (I would like to credit  the clearly and simply blog for the map and idea)

Here’s the result


and here’s the code

Now since this map is just a bunch of named shapes, we can apply the same principle to any set of shapes. Here’s a Santa with bits of his face heatmapped according to the data shown.
and here’s the code

For more stuff like this and to download this example, see the ramblings site

About brucemcp 225 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


7 + 10 =