Hi,

I want to suppress the showing of #N/A values in the Spreadsheet which result from the use of NA() function. The reason that I used the NA() function is that: I need to plot two columns of data as a line chart. I set missing values as NA() so that unwanted horizontal labels are not to be shown.

So I need to find a way to stop showing missing values as #N/A in both the Spreadsheet and the chart.

Do you have an idea?