View Single Post
  #1   Report Post  
JahMuse
 
Posts: n/a
Default XY Scatter Plot - Stringline for Trains


I have a stringline chart I have made out of the XY scatter plot chart
for trains in our area. The file is a program that allows users to
input a train number (e.g. 520), start time (8:20 - using military
time) and a starting location and an ending location. This if for my
boss so he can experiment with various train schedule and see the
trains in a stringline diagram (time of day vs. mileposts for each
train). I currently have all the trains plotted against the mileposts
and, correctly, some trains start and end midway where as others
complete the entire run. My problem is I am getting some stringlines
that extend all the way back to the mileposts on the XY intersection so
the graph mostly looks good except for these long and sometimes dense
(with all the plots) lines heading across the chart. They are tied to a
0:00 point which I swear is not part of the data being plotted.

I would be happy to send the file to anyone curious enough to look into
this. My two help books have nothing on this so I am your hands gracious
reader.

Thanks-


--
JahMuse
------------------------------------------------------------------------
JahMuse's Profile: http://www.excelforum.com/member.php...o&userid=26470
View this thread: http://www.excelforum.com/showthread...hreadid=397389