Hi,

I'm trying to plot a lot of data with gaps in the columns (empty cells) and
would like to be able to plot the series with points omitted if either x or y
are zero. It seems that Excel, rather than assume that a blank cell is zero,
stops plotting there... Can anyone help me with this?

Even assuming zero values would be better...

Thanks,

Dave