I'm trying to plot a line chart, but there is a break in the line for every 0 entry... so I use an if statement to change the 0's to spaces ("") and is still creates a break in the line. Apparently excel 07 views txt as 0 as well.

Is there any way to have the chart skip all 0 or txt entries?