Google Sheets Line Chart: adjust horizontal axis limits to exclude missing cells

Question

I noticed that the horizontal axis fits X values even if the corresponding Y-values are missing. Is there a way to automatically adjust horizontal axis limits to exclude missing cells?

https://docs.google.com/spreadsheets/d/1X3BhDyideX-7kyJ9Y-7xvV1naAwWd9eDPfPy3pP94Ic/edit?usp=sharing (sheet "Horizontal Axis Limits")

Thank you.

user_13045193 · Answer

Use Data > Filter to hide blank rows. They will automatically be left out of the chart.

Alternatively, create a new data table that omits the blanks, like this:

=query(A1:B, "where B is not null", 1)

Then set the chart's data range to the new table.

Google Sheets Line Chart: adjust horizontal axis limits to exclude missing cells

1 Answers