Dates

[Guest]

I am charting by dates, but am not consistent on gathering info. I have info
from 9/31/2002, 12/31/04 2/4/5, 4/1/5, 4/18/5 and from then on info every two
weeks or so. But I need them to show up with the correct time intervals in
between. It should be a long way from 9/31/2002 to 12/31/04 and shorter
times from 9/1/6 to 9/15/6 to 10/1/6.

Is there away to have the chart picture the actual time line with correct
distances in between?

 

[Andy Pope]

Hi,

If those values where actual dates then the chart should attempt to plot
them as a Time series , which would give you the proportional gaps
between points.

But I suspect the are not all true dates and as such are being treated
as text for an categorical axis.

This looks doggy, 9/31/2002 , as September only has 30 days.

Cheers
Andy

 

[David Biddulph]

Yes. Make sure you use XY graph.

 

[Guest]

Geez Louise. All that frustration and you picked it right out. I had a bad
date right at the start. Works perfectly. Thanks, Tom