X-axis in correspondence with time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gilbert De Ceulaer - 28 Jan 2007 22:29 GMT

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!

Reply to this Message

David Biddulph - 28 Jan 2007 23:10 GMT

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.

Signature

David Biddulph

> Y-axis are values,
> X-axis are dates (day after day, with many days omitted),
[quoted text clipped - 12 lines]
> 4434 spam-mails zijn er tot op heden geblokkeerd.
> Download de gratis SPAMfighter vandaag nog!

Reply to this Message

Jon Peltier - 29 Jan 2007 13:36 GMT

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
_______

> 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.
[quoted text clipped - 15 lines]
>> 4434 spam-mails zijn er tot op heden geblokkeerd.
>> Download de gratis SPAMfighter vandaag nog!

Reply to this Message