X-axis in correspondence with time

[Gilbert De Ceulaer]

Y-axis are values,
X-axis are dates (day after day, with many days omitted),
so there is not a value for each day.
Now - on a line graph - the distance between day 1 en day 2 is the same as
the distance between day 2 and day 7 (if there are no values for days 3 to
6).
Is there a possibility to have the x-values expanded relative to time ?
And interpolate the missing values ?

Thanks,
Gilbert

 

[David Biddulph]

Under Chart Options/ Axes, you've presumably got X-axis as categories, but
you should get the result you want if you select time axis or automatic.
Another choice, of course, is XY (scatter) rather than line chart.

 

[Jon Peltier]

If Excel doesn't recognize the dates, Automatic gives you the regular
category-type axis. Changing it to Time-Scale will work only if the pseudo
dates (i.e., non-numeric, merely text that Excel cannot pares into a valid
date) are converted to true dates.

- Jon