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

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

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

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

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

Thanks Bernard your are awesome.

--
H. Frank Situmorang


"Bernard Liengme" wrote:

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