2 Replies Latest reply on Jun 30, 2016 10:16 AM by Nellie Rajarova

    Missing data shows as colored on a heat map

    Nellie Rajarova

      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.

      Heat map treating NULLs as zeros