I have some data (parts per million) where some of it is 1 or greater than one (but has an actual number.) However, some of the data simply lists "<1" ppm.

What is a good way to visualize this in a graph?

Should I pick an arbitrary decimal less than one, so that it can be shown on the graph? I feel setting it to zero would not be right either, as they went to the extent of listing it, so it must be significant.


Is it a univariate plot? If so, just bin the data and toss it into the lowest bin.

  • $\begingroup$ It is not. Currently I have it in histograms- but anything that shows as a <1 shows up as zero. (Excel Pivot Tables) $\endgroup$ – mitchmitch24 Dec 5 '17 at 16:51
  • $\begingroup$ A histogram is a univariate plot. A scatterplot is a bivariate plot. You could make a bar chart where all the <1's are in a bin. $\endgroup$ – generic_user Dec 5 '17 at 17:30
  • $\begingroup$ Oh, I did not realize. And that makes sense. Thank you! $\endgroup$ – mitchmitch24 Dec 5 '17 at 18:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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