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

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

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
 
1) Did you specify Line and Markers?
2) Try replacing empty cell with =NA() which will display as #N/A
best wishes
 
Back
Top