I recently needed to do a Train graph for an up-coming event at Bennett Brook Railway, and a search lead me to this thread.
I found "mnel"'s post above most useful in getting me going in the right direction, but it took quite a bit of fiddling around to get to a result that fitted what I needed. The 2 screen shots below show where I am up to currently.[img]http://www.mediafire.com/conv/9c80826fcd53e95a55f55902e178c91a88edfd35b5b7438eba5d9e9873e4febd4g.jpg[/img][img]http://www.mediafire.com/conv/a1ea51689e7bf617848016df402280a5c4fbfe6d900cd3ec150c3db398a34ffc4g.jpg[/img]
As the operations get quite intensive, I needed to be able to look at track occupance at each station, and out to station limits, hence, for instance, the 5 lines for Whiteman Village Junction (WVJ). These represent platforms 1, 2, 3, siding track 4, and WVJ North Jct. The line departing WVJ north forms a 5km circle, returning to WVJ from the south, hence WVJ South Jct at the top of the graph, with the vertical "jump" from there to one of the WVJ station tracks.
On this graph I have used blue for passenger trains, green for freight, and red for a mixed train, but you can select almost any colour you like.
Once set up, you can delete all the train data (may have to leave one point - haven't tried this yet)and as new data is added, a new graph is drawn.
If you hover the cursor over a train path on the graph, a dialogue box appears showing the train number, and time and location of the neares node. If you click on a train path, the data for that path is highlighted.
What I had not expected was that you can click on a node on the graph and drag it to a new location (say a different time) and the input data is adjusted accordingly. It can be a bit tricky getting on to the right node though if the graph is a bit congested at that location though.
The extra column for "location" in the input data is with the thought that it should be possible to enter a text location and get Excel to look up the corresponding distance.
To show where a train occupies both the main and loop at a station while the loco runs around, a loop is drawn in the train path by switching across to the loop at the end time for the shunt move and then entering an earlier time next corresponding to the start time for the shunt, back across to the main, and then the next time is departure time.
Hope this is of interest/use.