Missing dates in time series are not showing blanks in x-axis

Question

I made a combo chart where the x-axis is the date field. I have gaps in the date, but want my chart to reflect the gap. For example, I have big gaps in April, May, June, August, September, and October.

11/20/2020
7/21/2020
7/19/2020
4/30/2020
3/28/2020
3/28/2020

How do I show the x-axis with missing date ranges without altering the data? The data is being imported from a CSV elsewhere which I can not change, only read in.

Edit add:

I am using combo chart

My horizontal axis options look like this:

Answer 1

Unfortunately the Combo Chart doesn't support the Treat labels as text for the horizontal axis. The alternative is to use a different chart type like:

• Area chart
• Column chart
• Line chart

and maybe others

---

First change the chart type to one that supports the required setting, then uncheck the Treat labels as text checkbox

One way to do this

1. Open the chart editor
2. One the Setup tab, change the Chart type to one of the chart types mentioned above
3. Click the Customize tab
4. Click the Horizontal axis title to expand it
5. Uncheck the Treat labels as text checkbox

Related

• How to plot time series graph in Google Sheets?
• Timestamps in scatterplot
• How to increase precision of labels in Google Spreadsheets chart?

Answer 2

I found the same option that Rubén described but in a different place.

It was in the main chart setup page. Surely enough, unchecking Treat labels as text fixed it!

Note that this is a simple Stacked column chart and not a Combo chart.