Excel scatter graph line only "connects data points with line" even with #N/A in the source cells. I have tried using different scatter graph line types but all interpolate the data over the ranges where #N/A is returned in the source cell using the N/A() function. I have "show empty cells shown as gaps" selected.
Any bright ideas!?