Why Doesn't the XY-Chart Leave Gaps as it Should ??

[monirg]

Hi;

1) I used in the past either empty cells or values returned from the function NA() to intentionally leave gaps between data points joined by straight-line segments in a single series
(with Tools::Options::Chart:lot empty cells as --> leave gaps.)

2) In the following example:
Why does point 8 before the #N/A join point 1 after #N/A ??
Shouldn't the straight-line segments stop at point 8, and start again at the next point 1, and so on ??
i......X..........Y....
1 -0.2485 0.9273
2 -0.2499 0.9328
3 -0.2514 0.9383
4 -0.2529 0.9438
5 -0.2544 0.9494
6 -0.2559 0.9549
7 -0.2573 0.9604
8 -0.2588 0.9659
9 ....#N/A.....#N/A
1 -0.2214 0.9341
2 -0.2227 0.9397
3 -0.2240 0.9452
4 -0.2253 0.9508
5 -0.2267 0.9564
6 -0.2280 0.9619
7 -0.2293 0.9675
8 -0.2306 0.9730
9 ....#N/A.....#N/A
etc............................
etc............................

3) If "" is returned instead of #N/A, the data points & the straight-line segments become invisible (can't be displayed !!)
If #VALUE! is returned instead of #N/A, the straight-line segments joining each 8 points extend to (0,0) !!

Does the above make any sense ??
What should the returned value be at points 9s to create the gaps ??

Would appreciate your comments / suggestions.

Thank you kindly.

 

[Andrew Poulsom]

You will get a gap if the cells are truly empty (blank).

 

[monirg]

Andrew;

OK.
The X & Y values are returned by formulas, including points 9s.
I suppose one can't return blanks, since once a value is returned to a cell then the cell is no longer empty, even if the returned value is nothing!

Can't use individual series for each 8-point set. Too many sets!

Can you think of a workaround ?? Or empty means empty and that's it!!

Regards.

 

[Andrew Poulsom]

Maybe you can use the technique here:

http://www.andypope.info/charts/brokenlines.htm

 

[monirg]

Andrew;

Thank you for providing the link.
The idea is certainly worth pursuing!

Regards.