Dates
 

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?

Dates
 

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

tbyrd007 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Dates
 

Yes. Make sure you use XY graph.
--
David Biddulph

"tbyrd007" wrote in message
...
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?

Dates
 

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

"Andy Pope" wrote:

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

tbyrd007 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info