I'm trying to scatter plot some data that's based on a formula, and it's got gaps in it. I can set these gaps to zero, but when I do, it puts the 0,0 point on the plot. This is a BIG problem since I'm trying to do a regression on the curve plotted and the 0,0 point is blowing the curve.
I've tried making the formula output the "" empty character, and the formula works and gives me empty cells, but the plot then goes completely nuts and plots the EMPTY data points as zero on the x-axis.
I've also tried the "hidden and empty cells" options, and all three choices (gaps, zero, or connect with line) seem to have NO effect on the plot.
Any ideas?
Bookmarks