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

monirg

Well-known Member
Joined
Jan 11, 2005
Messages
629
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::plot 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.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
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.
 
Upvote 0
Andrew;

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

Regards.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top