Thread: Time series data plots null values as zeros

Hi there. I can't remember how to prevent null values in time series data sets plotting as zeros. I'm sure there's a simple option. I've attached an example of the problem.

Thanks

Randy

Hi,
To prevent null value when charting, type in the empty cell the formula =NA()
To do this select the value of column Water Level > Search (blank) and Replace =NA()
See attached result
Hope this helps
Best regards

or simply type #N/A in the blank/empty cell. These are equivalent of missing values in excel.