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!