What value can I use to specify a “null value” (a value that is ignored when creating the graph) into the Grapher worksheet?
A. Grapher automatically ignores any text strings (non-numeric values) when creating the graph, so any text string could be used to indicate null values (i.e. N/A, no data, x99). In addition, Grapher 3 has added the ability to specify certain numbers as null data. After creating the graph, double click on the curve and click on the Clipping tab. Place a check mark in the Use Criteria checkbox and then press the Criteria button. Place a check mark in the Use NULL criteria box and then press the Add button. Type in the value that represents the null data (i.e. 0 or 99) and press OK in the open dialog boxes. The graph will redraw with the null data being ignored.
Related Questions
- How can I enter a "null value" (a value that is ignored when gridding or performing mathematical calculations) into the Surfer worksheet?
- What value can I use to specify a "null value" (a value that is ignored when creating the graph) into the Grapher worksheet?
- Can I specify a default value of "SYSDATE" (the current date) for a report parameter?
