Discontinious Line in XY Graph

[Paul]

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

 

[Jon Peltier]

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

 

[Andy Pope]

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

 

[ShaneDevenshire]

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