Not plotting null or text data

  • Thread starter Thread starter Vince F
  • Start date Start date
V

Vince F

I am trying to plot data from cells that have a conditional that returns
either a null "" (I could also make it text) or numerical data. I wish only
to plot the numerical data, but the null (or text) data plots as zero no
matter what I do. Since the states of various cells may change, I don't wish
to exclude those cells permanently. Any thoughts would be greatly
appreciated. Thanks in advance.
 
Hi,

As far as charts are concerned "" is text and as such is plotted as zero.
Use NA() instead, charts will interpolate the points.

Cheers
Andy
 
Andy
That works, thanks!
--
Vince F


Andy Pope said:
Hi,

As far as charts are concerned "" is text and as such is plotted as zero.
Use NA() instead, charts will interpolate the points.

Cheers
Andy
Click to expand...
 
Back
Top