Charting discontinuous data

[waterrockets]

I have 6 columns of data, but some rows only occupy columns 1-3, and some only occupy columns 4-6. I want to have a line chart, where the lines stop if there is no data.

If I put 0s in the empty data, the line chart drops to the floor, as expected. If I just select the row with empty cells, it gives me a formula error.

Any ideas here?

Thanks!

[waterrockets]

Ok, I found the answer (use #N/A in the empty cells) here: http://groups.google.com/group/micro...e1dc023e4c78a2