| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 53670 | 2005-01-24 01:09:00 | Help with Excel please | Chris Randal (521) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 317457 | 2005-01-24 01:09:00 | I want to turn a train timetable into a graph, but can't see how, or even if, it can be done. Any Excel aces available to point me where to go start? Many thanks Chris |
Chris Randal (521) | ||
| 317458 | 2005-01-24 01:37:00 | View|Toolbars|Chart should get you going. Select the data you want to chart, click the down arrow by the chart icon to select the chart type, then click the chart icon and you should have a basic chart that you can tweak. I know little about charts, so there are probably experts around who can give you more guidance. HTH |
Tony (4941) | ||
| 317459 | 2005-01-24 08:50:00 | Anybody else? | Chris Randal (521) | ||
| 317460 | 2005-01-24 09:11:00 | I want to turn a train timetable into a graph, but can't see how, or even if, it can be done. Hi Chris Exactly what are you wanting to graph? On the vertical scale I expect you will have the train arrival/departure time and I presume you will have the train stations on the horizontal scale. If you wanted to plot multiple trains on the one train line on one graph, then you will have a number of parallel lines extending from the bottom left corner of the graph to the top right. Is this what you want? If so, then laying out the timetable in a grid pattern and following Tony's advice should get you going. However, if you want multiple train lines possibly with multiple trains, you will have a non-consistent horizontal scale (being the stations) and the graph will have multiple discontiguous ascending parallel lines and the graph will be meaningless. I don't think this is what you want. There is nothing remotely close to what you requested on the Mr Excel help forum (www.mrexcel.com) but then there is a first time for everything. You could post your question in that forum and see what response you get. I'd be curious to hear Parry's thoughts on this, given he is our resident Excel guru as well as a frequent member (should that be MVP?) of Mr Excel. Andrew. |
andrew93 (249) | ||
| 317461 | 2005-01-24 10:39:00 | Hi, I agree with your comments Andrew. :D I believe you probably want something that has a horizontal line for each station with plot points at the times where there is a stop at that station. So that probably means times along the x axis and stations along the y axis. Im too tired to look at this now but I'll see what graph is best tomorrow if I get a chance, but a line graph is probably the ticket (spot the pun). In Wellington its a bit of a subjective exercise. Our trains are roughly 10 mins late except if your running late then of course they will run to schedule, and you will arrive just in time to wave goodbye. :p :D |
Parry (5696) | ||
| 317462 | 2005-01-24 19:27:00 | Anybody else? Sorry I couldn't help... :blush: |
Tony (4941) | ||
| 317463 | 2005-01-24 21:24:00 | Hi, Ive had a look at this but you would need to indicate what you expect as a result Chris. There could be many ways to attack this problem but its best to work back from what you want the result to look like. There are many clever ways to make charts that dont seem possible from the standard list, and one of the best experts in this is Jon Peltier. Take a look at his site here (peltiertech.com) and you can see he's a bit of a wiz. You could do this as a horizontal stacked bar chart with each series representing a station, and the departure times being the vertical axis. Its difficult to explain and easier to show you, and I dont think PF1 allows attachments. Perhaps send me a PM with your email address and I will send you an Excel file with an example graph. regards Parry. |
Parry (5696) | ||
| 1 | |||||