How to make X-axis represent time?

My data columns are number, date. Observations are generally daily, but with a significant number of missing values (days) – 226 observations over 14 months. How can I make the X-axis represent time, with horizontal space for missing date data, rather than simply a series of equidistant points with each labeled by its date?

Use chart type “x-y-scatter” rather than “line”.


OK! That did it. I had thought it was already an x-y-scatter, because that’s what it looked like.