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

Grapher's Null criteria feature can be used to remove NULL data from the a graph. 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.
  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, if needed.
  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:
    1. Uncheck the Data columns only box.
    2. Click the Select columns button.
    3. Check the boxes in front of any column that can contain the NULL criteria and click OK.
  10. Click OK in the Criteria dialog and the NULL values are removed from the graph.

 Grapher line plots with and without null criteria applied

Two line plots showing the effect of applying a NULL criteria to a graph


Updated September 21, 2018

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


Please sign in to leave a comment.