Forum Discussion
Public transport map
Hello all!
I need to draw a public transport map (like a subway map). On this map I will have to indicate the time of arrival and departure of each line service for each station. The map should be composed by points (train stations) and lines (train services). I would like to use VBA since The size of the points should follow the number of trains stopping by (the highest is the number, the biggest is the point). Each train service should be represented by one line, and the weight of the line should depend on the frequency of the train service. Do you think this is possible? Or do you think I should use another tool?
Thanks!
2 Replies
I agree with Excelonlineadvisor that there are other tools—Microsoft's Visio, for example—that are well suited to this task. However, to demonstrate that Excel can be used for a simple map, see the attached workbook. Read the notes on the _Info worksheet.
It might not be important to you, but each station's information box uses a fixed-width font (monospace typeface)—specifically, Courier New—for vertical alignment of the values. Other fixed-width fonts, such as Cascadia Code, Consolas, Lucida Console, and OCR A Extended are available. I intentionally did not include the days of the week in the info boxes, but those could easily be added.
I assume you are familiar with Excel tables.- creating a public transport map with dynamic features using VBA in Excel may not be the most suitable approach, there are plenty of other tools available that can help you achieve your goals more effectively. Choose the tool that best fits your needs and technical skills.
