Missing date in the chart
The table in this example shows dates and values. There is a missing dates. It causes a big blank space in the chart.
Excel provides options to display dates on the axis that can fix this blank space. Do right-click on the Y-axis and select Format Axis.
In the Format Axis menu find Axis Type and switch it to the Text axis value.
Dates in the chart have no blank space, now.