Pivot table to exclude 0's

Try using a normal line chart with markers rathe than the Stacked sub type you currently have.
When you use Stacked the empty cells are treated as zero.