X-axis in correspondence with time
 

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

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
4434 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!

X-axis in correspondence with time
 

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.
--
David Biddulph

"Gilbert De Ceulaer" wrote in message
...
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

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
4434 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!

X-axis in correspondence with time
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"David Biddulph" wrote in message
...
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.
--
David Biddulph

"Gilbert De Ceulaer" wrote in message
...
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

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
4434 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!