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