So, this project I'm working on shows the percentage of reports submitted each month that are successful.
However, for some months, no reports are submitted, so there is no data. It doesn't really make sense to record it as 0% or 100%, since the month wasn't a total failure or totally successful. And it also doesn't make sense to show it as somewhere in between the months on either side, because that's not correct.

Ideally, the line would just stop at the previous month and start back up again at the next month.

Does anyone know a way to do this?

(I have my empty cell set as =NA(). And in the graph settings, I have "Show Empty Cells As:" set to "Gaps". I'm using Excel 2007)