Not plotting null or text data
 

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.
--
Vince F

Not plotting null or text data
 

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 Pope, Microsoft MVP - Excel
http://www.andypope.info
"Vince F" wrote in message
...
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.
--
Vince F

Not plotting null or text data
 

Andy
That works, thanks!
--
Vince F


"Andy Pope" wrote:

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 Pope, Microsoft MVP - Excel
http://www.andypope.info
"Vince F" wrote in message
...
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.
--
Vince F