Line charts show zero or #N/A value as zero not as gap even after checking the hidden cell box.

smherring4 If I understand your requirement correctly, you want the line chart to show a gap where your value is either 0 or #N/A. 

The workaround is below:

1. In a column (preferably next to your horizontal series column), add this formula:

=IF(OR(C2=0,ISNA(C2)),NA(),C2)

where C is your original value column, to force all 0 and #N/A to be an error #N/A

2. Create a line chart with your horizontal series column and the new column created by Step 1

3. Select the new column with formula in Step 1, press F5 then click on "Special", tick "Formulas" and "Errors" only (i.e. untick all other options under Formulas and keep only "Errors" ticked)

3. While all cells showing #N/A in the new column are selected by Step 2, press Delete

The result will be reflected immediately in your line chart with gap where you want. Attached workbook is a sample.