This content has been marked as final. Show 2 replies
I am using a temperature diverging heat map and have many missing values in my dataset.
I could only see the missing values using indicator/tooltip as missing values but it is not obvious from the heat map as they show up colored.
Also I do not want want to center at zero to get the empty values to show up as white.
I found this solution from Joe (link below) but could not implement it on my sheet. Any help is really appreciated.