Animated Progress Bar For Map

[timpickup]

Morning,

I'm looking for suggestions to achieve the following situation:

We are having a charity bike rid from John O Grote's to Lands End on a stationary bike. We would like to display the progress from the bike ride on a TV from Excel. So a value of miles done will be entered regularly be it 5 miles or 100 miles. How could I create a map of GB showing the route and progress as the value entered goes up and up.

Any suggestions would be much appreciated.

Thanks in advance!

 

[oldbrewer]

if the route is shown as a straight line with towns as points on that line it is doable. You know the route and miles between towns, so it could be represented as a scatter plot with points joined up, underneath could be the progress scatter plot with only points zero and current miles plotted. Otherwise look at route planner apps etc....