Plotting NA() or #N/A data points

[Doug]

I have formulas that return the NA() or #N/A to cells I used for plotting on
charts. The last two cells do not show up on the chart, as intended. However,
when I enter the data into the first of the two cells, it plots the last data
point as zero.
Ex: Jan-Oct has data, Nov and Dec default to the above. When Nov is filled
in, the chart plots Nov and then adds Dec at zero value and returns #N/A in
the axis.

 

[teylyn]

I have formulas that return the NA() or #N/A to cells I used fo
plotting on
charts. The last two cells do not show up on the chart, as intended
However,
when I enter the data into the first of the two cells, it plots th
last data
point as zero.
Ex: Jan-Oct has data, Nov and Dec default to the above. When Nov i
filled
in, the chart plots Nov and then adds Dec at zero value and return
#N/A in
the axis.

Check the formulas that provide the values that are plotted. #N/
values will not be plotted by default. zero values may be plotted
unless interpolation is set differently