I've been tasked with doing a network diagram of our offices (8 in total) across two different cities. Our network is all on a single flat subnet (10.1.X.X / 255.0.0.0) and all sites are connected ...

You can make an Excel scatter plot assigning one of the variables in each record to the x-coordinate and one to the y-coordinate on a standard graph axis.