Graphing Time against distance

  • Thread starter Thread starter Spaceman
  • Start date Start date
S

Spaceman

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.

Can anyone help or advise?
 
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.
Click to expand...

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 the
"Time" column as the X-axis. The Code is simply a number assigned to each
stop. If I have interpreted your request correctly, the chart should look
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/Excel/Charts/axes.html#ArbGrid.
 
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.
 
Thanks for that, its looking good. Just 2 things, I cant seem to swap
the axes (I have time on the Y axis :S)
Click to expand...

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.
Click to expand...

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