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 c...
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.