1) Did you specify Line and Markers?
2) Try replacing empty cell with =NA() which will display as #N/A
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Frank Situmorang" wrote in message
...
Hello,
Here is my problem, I have 2 series on the y axis dan Date time series on
the X axis. how come the markers on the 2nd data sereies are not all
connected.
Here is my worssheet layout and the process I do it:
Date LME Price Local price
---- ----------- -------------
1/1/08 100
1/2/08 200
.
.
.
.
1/1/08 300
1/3/08 350
Then I data sorted by date then tere will be duplicate date of course.
I appreciate your help what goes wrong.
Thanks in advance,
Frank
--
H. Frank Situmorang