To connect the line with missing data points in between, you can use the "Connect data points with line" option in Excel. Here's how:
- Select the data points you want to connect with a line.
- Right-click on the selected data points and choose "Format Data Series" from the menu.
- In the "Format Data Series" pane that appears on the right side of the screen, click on the "Series Options" tab.
- Under "Plot Series On", choose "Primary Axis" if it's not already selected.
- Check the box next to "Connect data points with line".
- Click "Close" to apply the changes.
This should connect the data points with a line, even if there are missing data points in between. The line will simply skip over the missing data points.