BookmarkSubscribeRSS Feed

Missing values in Cell Plot


Community Member


Jul 7, 2017

I'm using the cell plot tool to create a heat map but I have some cells that are missing data, this creates several Xs on my cell plot. Is there any way to hide these Xs? I do not want to hide certain colums or rows as there are needed values in the row. Is there a way to hide individual cells? I've attatched a picture of the issue

Screen Shot 2017-07-07 at 5.10.04 PM.png




Jun 23, 2011

The X is an honest representation of your data. It indicates that the value of this cell is unknown and cannot be shown. It might be zero, it might be low, it might be high, you just don't know what the value is.

On the other hand, it might also be honest in some cases to replace the missing value with a relevant value to suppress the appearance of the X. For example, I track the minutes used by each family member that appears on a monthly cell phone bill. My son joined the plan after I started it and my wife and daughter joined a long time after him. A cell plot of the minutes (over time) for all of them yields a plot with a lot of X cells like yours. In this case it might be reasonable (using one-sided sequential color scheme for all responses) to replace the missing value code with zero to now represent a baseline. In this case, the zero does not represent the minutes that they might have used if they were on the same plan but instead represents the actual minutes before and after they came on the plan.

Learn it once, use it forever!

Super User


Jun 22, 2012

There does not seem to be any option to change the missing value to just an empty cell.  I also checked the posibility of being able to change the output via JSL, and the display object does not give access to the individual cell.