How to create a heatmap doughnut chart, as in the example shown belowLets say that we want to create a circular color ramp, as used in
This is actually 2 steps, using this data
So the task is now to calculate a smooth transition between each of these colors and to circle back from Chips to Vegetables, where each transition is centered around the calculated color for each category, as below
Here are the calculated colors
here's the snippet for that
Since each slice of the doughnut is now of equal size, (remember we are using color instead of size to show intensity), the color of each slice is calculated by its relative position along this circular scale, as per the snippet below
Here's the complete code for the module that creates the chart.
For help and more information join our forum,follow the blog or follow me on twitter .
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Color Fiesta > Create a heatmap in Excel > Color ramp library >