Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
histogram and a line graph on the same graph? | Excel Discussion (Misc queries) | |||
Bar graph to line graph | Charts and Charting in Excel | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Bar graph and line graph overlayed | Charts and Charting in Excel |