Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Geez Louise. All that frustration and you picked it right out. I had a bad
date right at the start. Works perfectly. Thanks, Tom
 
Back
Top