Graphing Time against distance

On Fri, 24 Oct 2003 13:25:57 -0400, Spaceman =

wrote:
I am trying to get Excel to draw a train graph. This is a grpahical
representation of a timetable, with railway stations on the vertical
axis, and time along the x axis. However, I cant get excel to display
this properly. Each line should display the progress of a train,
including stops, etc.

Assuming your data looks like this:

Location Time
Denver 12:00
Chicago 4:00
Chicago 5:00
New York 10:00

The first "Chicago" entry is arrival time; the second is departure time.=
=

Add another column to the data like this:

Location Time Code
Denver 12:00 1
Chicago 4:00 2
Chicago 5:00 2
New York 10:00 3

Now do an XY scatter chart with the "Code" column as the Y-values and th=
e =

"Time" column as the X-axis. The Code is simply a number assigned to ea=
ch =

stop. If I have interpreted your request correctly, the chart should lo=
ok =

about right except that you will need to relabel the y-axis. Jon shows =
us =

how to do this at =

http://www.geocities.com/jonpeltier/...s.html#ArbGrid.

-- =

Dave
dvt at psu dot edu

Thanks for that, its looking good. Just 2 things, I cant seem to swap
the axes (I have time on the Y axis :S) also Some trains dont stop at
intermediate stations - and excel is putting a gap, rather than
continuing the line.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

On Fri, 24 Oct 2003 16:28:06 -0400, Spaceman =

wrote:

Thanks for that, its looking good. Just 2 things, I cant seem to swap
the axes (I have time on the Y axis :S)

Select the chart, go to the menu and select Chart | Source data | Series=
=

tab. Exchange the stuff in the X values box with the stuff in the Y =

Values box.

also Some trains dont stop at
intermediate stations - and excel is putting a gap, rather than
continuing the line.

Tools | Options | Chart tab | Plot empty cells as interpolated.

-- =

Dave
dvt at psu dot edu