How to set a date-based x-axis in Numbers with incomplete data? I have a simple table (date, value) and I want to display that data in a chart.
This is my current chart:



As you can see, I don't have a value for each day, there is about one month between the last two dates. This makes my chart looks wrong, because it creates the same spaces between two dates, irrespectively of the date value.

If I create a new table with one row per day, I get the expected chart. But I need to create all that useless empty rows:



Is there a way to create a chart with a date-based x-axis? Can I create a chart that looks like the second one, but with the data from the first table?

Thanks.
You can make a plot using your x,y values and then change the x-axis to be what you want. maybe your x values only run from 0 to 5 but y-data has x-values from 0-50. Click on your plot and then click on the axis tab in the right sidebar. From here you can select the x-axis and on the panel that appears you can input the min and max x-values you wish to use. See figure below.