X-axis in correspondence with time

  • Thread starter Thread starter Gilbert De Ceulaer
  • Start date Start date
G

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
 
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.
 
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
 
Back
Top