How to have Excel chart connect data points when no value?
Solution 1:
- Go to the
Select Data
dialoge box for the chart - click
Hidden and Empty Cells
- Change
Show empty cells as
toConnect data points with line
Select Data
dialoge box for the chartHidden and Empty Cells
Show empty cells as
to Connect data points with line