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