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

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

Hi,

And to add to Jon's reply.
As well as the cell being truly empty make sure the option Plot empty
cells as: Not plotted is set.
menu Tools Options Chart

Cheers
Andy

Paul wrote:
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

Actually there is another way to do this, not particularly pleasant but it
works:

=SERIES('Error Bars'!$J$5,'Error Bars'!$A$21:$A$31,('Error
Bars'!$F$21:$F$24,'Error Bars'!$J$1,'Error Bars'!$F$26:$F$31),1)

In the above series formula the series is plotted as three line segments,
one of which is an empty cell outside of the data area.

Regards,
Shane

--
Thanks,
Shane Devenshire


"Paul" wrote:

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