Dear Jon,
Thanks for your helpful (as always) reply. I have used the NA() "solution"
for many a year now and it has served me OK but, unfortunately not for the
current chart... It is a real pity that there is not a simple option to treat
NA() values like blanks... but that is hardly the most important of the
missing features in Excel 2007 charts.
Thanks again and very best wishes, Boris.

"Jon Peltier" wrote:

Boris -

There is no worksheet function that mimics a blank cell. NA() is the best
you can do if all you need is to skip a plotted point, but as you've
discovered, the connecting line is drawn across the skipped point. Apparent
blanks ("") plot a point at zero, which is even worse.

You could try Ed's suggestion, though using a 3D line makes me shudder. The
3D line would impose all limitations of 3D charts (no markers, no combo
charts, etc.) and of line charts (non-numeric X scale).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Boris" wrote in message
...
Hi, I am plotting large blocks of data on a scatter plot. I want to change
my
data and update though charts automatically so I use a series of if
statements to generate the data I will plot. My data should have numerous
blanks so I can make my if statement give me a blank string, or zero value
,
or some other value, or NA() when my test fails and otherwise give me the
result I want to plot. Fine. Null strings are plotted as 0, NA()'s are not
plotted. But the parts of the plot ranges containing data (where the data
passed my test) are connected by straight lines (representing the parts of
my
plot ranges where the test failed and the output is NA()) when I wanted to
leave these segments as gaps in the data line. Is there any way of telling
Excel not to join the points together ie plot only my values and not plot
the
joining lines where there are NA()'s (that is, mimic having true blank
cells)? I have resorted to writing a simple bit of code to give me the
data I
need but this is not the elegant solution I was hoping for...
Many thanks and best wishes, Boris.