The source data is in columns A (for Y values) and B (for X values). Say A1
through A10 have {6.53, 6.41, 5.89, empty cell, empty cell, empty cell,
empty cell, 6.74, 7.00, 6.50} and B1 through B10 have {7.19, 6.92, 6.74,
6.17, 6.34, 6.57, 6.47, 6.88, 7.12, 6.76}. NOTE that the empty cells result
from an IF statement that if something happens the cell = "". When plotted
as XY Scatter, the chart does not handle properly the empty cells. It
actually becomes like a Line plot, where the X axis is categorical instead of
numerical. I have to CLEAR ALL each of the empty cells so the XY Scatter
works. THe problem is I have thousands of data points and the empty cells
occur randomly throughout the series. Any advice?