User Experience Stack Exchange is a question and answer site for user experience researchers and experts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Give a table of numeric data in which many cells contain zero, under what circumstances would it be appropriate or preferable to present the zero-value cells blank or otherwise obscured (eg. in lighter ink)?

Assume it is explicit that the table contains no missing values, so a blank cell is not ambiguous.

share|improve this question
up vote 5 down vote accepted

I think that you should display zero values in light gray. However, what to display depends on context, e.g.

  • If you are displaying financial information, displaying zero seems appropriate to me

  • If you are displaying the number of widgets sold by different sales reps, then I'd display a simple dash ("-") to illustrate that no widgets have been sold yet

share|improve this answer
I agree completely. It is completely dependent on context. Is the zero a placeholder or an actual value? – Charles Boyung Nov 5 '10 at 19:04

I'd say when there are an overwhelming number of zero values compared to the non-zero values.

In this case having blanks (or dimmed zeros) would make the non-zero values stand out more. They'd be easier to spot and verify.

share|improve this answer
I agree: it would depend on whether or not the tabled data is sparse (ie. mostly zero values) or not (ie. only a few zero values). It also would depend on your use case. Perhaps zero values are the most important, and should be highlighted. – lucasrizoli Nov 5 '10 at 13:45

If the zero value is of lower importance, it is my preference to gray it out to allow the eye to easily skip or ignore those values when scanning the list. Omitting it altogether can be less clean of a look than having the gray-colored placeholder.

share|improve this answer

The Office for National Statistics uses a - to denote nil in its tables. It lets the numbers stand out.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.