Paul -

The cell has to be empty. "" doesn't work (as in an IF formula that returns
a value or an apparent blank).

You can actually hide the line manually. Click once on the series, then once
on the segment you want gone, then use the CTRL+1 (numeral one) shortcut to
format the selected object, and choose None for a line style on the Patterns
tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Paul" wrote in message
...
How do I make a line in an XY graph discontinious. I have it working in
one
place but not in another. I cannot figure out what makes it work this
way.
It seems if you leave an empty X value has something to do with it.

Thanks