Sorry for missing information.
It is excel 97, line curve (the default one)

When i set xvalues (say "=Sheet1!$A$2:$A$5") in chart wizard, it is ok.
But when i set it by program or in macro's debug window, not ok.


"Tom Ogilvy" wrote in message ...
Are you using a scatter plot. If not, that is the only type chart that
would do what you describe.

--
Regards,
Tom Ogilvy

Alan Pong wrote in message
om...
a = array(cdate("2003/12/5"), cdate("2008/9/3") ,cdate("2013/9/2"),
cdate("2033/8/28"))
activesheet.chartobjects(1).chart.seriescollection (1).xvalues=a

b = array(.93, 3.26 , 4.35, 5.21)
activesheet.chartobjects(1).chart.seriescollection (1).values=b

what i see is that the x distance between two consecutive points is
uniform.
(the fourth point should be more far away.)

any cue?
thanks.
rgds.
alan