Home > OS >  Google Sheets Line Chart: connect missing points
Google Sheets Line Chart: connect missing points

Time:09-22

How do I connect missing points in a Google Sheets Line Chart with a straight line? enter image description here

When you want to check it using Google Apps Script, you can also use the following script.

function myFunction() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const chart = sheet.getCharts()[0];
  const c = chart.modify().setOption("interpolateNulls", "true").build();
  sheet.updateChart(c);
}

Reference:

  • Related