How can I use a NULL value so data does not display in Grapher?

This article provides steps for how to exclude a data value or data range from appearing on a graph. Can also be used with values below a non-detect limit.

By default, Grapher displays all data in the data columns for every plot. Sometimes data is included in the worksheet that should not be plotted. For example, an instrument may record -9999 when the data value cannot be determined. When this happens, the -9999 will appear on the graph. To remove the value and tell Grapher that the value is a NULL value, follow these steps:

  1. Create the plot as normal by clicking on the appropriate Home | New Graph command.
  2. Click on the plot to select it. For instance, you might click on the Line/Scatter Plot 1.
  3. In the Property Manager, click on the Data Limits tab.
  4. In the Criteria Filter section, change the Criteria to Null.
  5. Click the Set button.
  6. In the Criteria dialog, check the box next to the Use NULL criteria option.
  7. If a single NULL value exists in the data set:
    1. Click the Value button.
    2. Type the NULL Value, such as -9999 and click OK.
  8. If a range of NULL values exist in the data set:
    1. Click the Range button.
    2. Type the Low and High values. For instance, you might type -999999 for the Low and 0 for the High if all negative values should be ignored. Click OK.
  9. By default, all used data columns (X, Y, Z columns) in the worksheet are examined to look for the NULL value. If only some of the data columns should be examined or if the NULL information is in another column, uncheck the Data columns only box.
  10. Click the Select columns button.
  11. Check the boxes in front of any column that can contain the NULL criteria and click OK.

Grapher's Criteria dialog allows individual data values or ranges of values to be excluded.
Set the NULL value in the Criteria dialog to remove points from the line/scatter plot.

  1. Click OK in the Criteria dialog and the NULL values are removed from the graph.


Updated December 11, 2017

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.