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

#### monirg

##### Well-known Member
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 ??

Thank you kindly.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Andrew Poulsom

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

#### monirg

##### Well-known Member
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.

#### monirg

##### Well-known Member
Andrew;

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

Regards.

1,191,366
Messages
5,986,238
Members
440,012
Latest member
StumpedGump1987

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back