Hi,
I'm working on using excel solver to solve for TSP.
Let's say I have coordinates for 50 cities and plotted using scatter plot in excel as shown in the graph below:
1.jpg
After using solver to solve for TSP, I managed to get the sequence of visiting the 50 cities,
let's say:
11 18 31 33 14 6 7 5 15 16 17 8 41 20 49 39 35 36 44 30 42 37 9 19 48 12 10 23 32 13 24 38 29 25 26 47 4 27 3 50 40 22 34 43 21 45 1 28 2 46
However, I don't know how can I connect these dots in the above graph according to the sequence of cities I got from solver.
Can anyone help me with the plotting?
Thanks!
Bookmarks