When visualizing data in Google Sheets, one encounters the problem that the \(x\) axis cannot automatically fill in the missing gaps for text values (such as calendar weeks). To solve the problem, one generates a continuous date series, counts the occurring cells themselves and then visualizes the cumulated totals.
The standard diagram, which counts the number of occurring values, has the mentioned gaps (in the example the calendar week "24/2020" is missing):
The same can also be done for calendar weeks (and, if required, for quarters and years):
Cell \(F1\) the start date and \(F2\) the number of days relative to today's day. Now we count the different values of the continuous date series:
This allows the above diagram to be displayed without any gaps: