Line chart, skipping 0 or text entries

[Lithium78]

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?

[DonkeyOte]

Have you tried replacing with #N/A

[Lithium78]

That does work, but it makes the data source so ugly. I think I'm just going to deal with the break in the trend lines.

Thanks!

[ChemistB]

I usually use a conditional formatting on the data source to format #N/A with white text to keep it looking clean.

[Lithium78]

Nice thanks you!