Try this

Select (highlight)the Excel graph, then from the menu Tools, select Option, click on the tab Chart, check the radio button "Plot empty cells as interpolated".