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

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
scatter chart with gaps in series (XL 2007) 7
How do I plot "" as empty rather than zero in a chart 1
Excel 2007: Lines not displaying on Scatter Plots 1
XY Scatter Plot - Non-numeric data 3
How do I not plot zero values that result from a formula in Excel? 1
Charting should not plot NULL as a zero 1
Prevent non-numerical data (e.g. text) from plotting on a chart 1

Back
Top