THAT'S it!!!..terrific!!..
man, i've been thinking on this for a couple of days, and now you with a
simple check-box solve my problem..
that a mixture of embarassment and relief:)..thanks!!

"smartin" wrote:

Xaraam wrote:
hey Smartin!

the x-y chart will give me the same graphical distribution as using a chart
with date on the x axis.
If u insert into a excel sheet the data i provided in the previous post and
make 3 chart, 1st one without date on the x axis, the 2nd with (for this 2
charts use a line chart) and the third as a x-y chart (using number as y axis
and x as date), i guess u easily see that the best one to consult is the
first one.

can you remenber any other solution without be programming on VBA?

"smartin" wrote:

Not sure I follow you, but would this chart look better as an X-Y chart?
Drawing lines between the points would get very messy indeed since you
have multiple Y values at each X, and 20000 points. Also, the X-Y
version will allow you to space the X-axis dates proportionally, instead
of evenly spaced.


On your line chart, if you go to Chart Options, Axes, Category (X) Axis,
does changing the option to "Category" give you the result you want?