PDA

View Full Version : Drawing Lines Between City/State Pairs



Eric Frost
12-08-2010, 03:49 PM
We recently received a request ( http://www.mapforums.com/origin-destination-pairs-14727.html ) for a modification to our drawing lines macro so that it would work with City/State pairs.

Take a look at the existing tool and the post here first --

http://www.mapforums.com/drawing-lines-mappoint-coordinates-excel-12467.html

With this new tool attached, instead of plotting using lat/lon coordinates, it draws lines between City/State pairs.

A new screenshot with lines between Chicago and various other cities in the U.S. is below.

Have fun and let me know well it works for you and if you have any custom requests!

Eric