Morning all,
I'm playing around with the Map graphing abilities of Excel within my Office365 subscription.
I've managed to get it to plot some data for major European countries but not for towns local to my area in Cumbria, UK.
Do I need an add-on?
Anyway. An example of the (made up) data I'm am playing with is:
[TABLE="width: 212"]
<tbody>[TR]
[TD]City[/TD]
[TD="align: right"]residents[/TD]
[/TR]
[TR]
[TD]Windermere[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]Ambleside[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Troutbeck[/TD]
[TD="align: right"]85[/TD]
[/TR]
</tbody>[/TABLE]
Which simply fails to plot at all.
How do I plot local data down to town level? Simply sticking a ,UK after the town name has no effect.
This works, however.
[TABLE="width: 452"]
<tbody>[TR]
[TD]country[/TD]
[TD="align: right"]residents[/TD]
[/TR]
[TR]
[TD]france[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]germany[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]spain[/TD]
[TD="align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]
I'm playing around with the Map graphing abilities of Excel within my Office365 subscription.
I've managed to get it to plot some data for major European countries but not for towns local to my area in Cumbria, UK.
Do I need an add-on?
Anyway. An example of the (made up) data I'm am playing with is:
[TABLE="width: 212"]
<tbody>[TR]
[TD]City[/TD]
[TD="align: right"]residents[/TD]
[/TR]
[TR]
[TD]Windermere[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]Ambleside[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Troutbeck[/TD]
[TD="align: right"]85[/TD]
[/TR]
</tbody>[/TABLE]
Which simply fails to plot at all.
How do I plot local data down to town level? Simply sticking a ,UK after the town name has no effect.
This works, however.
[TABLE="width: 452"]
<tbody>[TR]
[TD]country[/TD]
[TD="align: right"]residents[/TD]
[/TR]
[TR]
[TD]france[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]germany[/TD]
[TD="align: right"]44[/TD]
[/TR]
[TR]
[TD]spain[/TD]
[TD="align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]