Hello everyone,
I am trying my hands at the Heatmap chart. I like what it does and have mostly managed to customize it the way I want.
However, I was wondering if there is a way to assign colors to the cells similar to how you can do 3 color scale conditional formatting in Excel.
For example, for the given set of values, the max value is shown with green marker color, the min in red, the median value in yellow.
And then all other values follow a gradient between these 3 primary colors based on what the value is.
The heatmap already does a gradient of color, and changes the shade from dark to light as the value goes down, but it does this in just one color, depending on which theme you chose.
If it helps, I have attached a sample from excel.
Thank you.
Alok.