scatter plot and missing data

[John McPhee]

I have several columns of data for which I want to plot x-y charts. The first column is the x, and the other columns will be y for different individual plots. There is missing data in the y columns. Excel treats the missing data as zeros, and plots the points along the x-axis. How to avoid this without setting up individual pairs of x-y columns and removing the rows that don't have full pairs?

Post script - it's ok. Discovered some errant formulae in some cells just after I posted. Got rid of them and all good now.