Not plotting null or text data

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.
 
A

Andy Pope

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
 
V

Vince F

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I don't want to graph "null" values? 1
Plotting NA() or #N/A data points 1
scatter chart with gaps in series (XL 2007) 7
Excel 2007: Lines not displayed on Scatter Plot 0
How do I plot "" as empty rather than zero in a chart 2
Plotting subset of time value data 0
XY Scatter Plot - Non-numeric data 3
plotting line charts with formula based 'gaps' 11

Top