Public transport map

Hello all!
I'm Rachele, a new member. I'm a transportation engineer and I need to draw a public transit map, but I would be nice if it could be dynamic somehow. I know this thread could be on a very advanced level and "Excel General" might not be the right Forum, but I wasn't sure where to ask.

Basically 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!

If the Train Times Of Arrival And Departure are stagnant (generally they don't change) I wouldn't use Excel. If you intend to automate the times by linking to some system that provides that data then "YES" vba may be the way to go. But you are going to require a lot more knowledge about VBA than it appears you currently have. You are looking at a big project providing automatic updates.


There are plenty of free programs on the internet that will provide you with a professional map presentation ... if you don't have to automatically update arrival/departure times.


The first link below is not free but the software program is excellent from my personal knowledge ... the remaining links are all free.

https://www.conceptdraw.com/solution...maps-metro-map


https://metromapmaker.com/
https://www.thunderforest.com/pricing/


The above links were obtained by googling "create transport maps" and represent a small number of free websites to be found.