Graph of 2nd serious in the Line type graph is not connected

[Frank Situmorang]

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

 

[Bernard Liengme]

1) Did you specify Line and Markers?
2) Try replacing empty cell with =NA() which will display as #N/A
best wishes

 

[Frank Situmorang]

Thanks Bernard your are awesome.