This is a UK map I produced for the UK as a shape, it is to scale and the parts are grouped as one shape, but each coloured part may be separated!
It was a trial for my final project to create a county map of the UK as a series of shapes, wish me luck!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Nice Darren, thanks for sharing
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
I will also be releasing a county map shortly, again as a series of shapes!
this map is hand drawn, although it will still be to scale I chose this route to minimise the number of points for each shape otherwise the map will be slow!
Shapes will be named with the county name so easily referenced from VBA to hide and show and also change the colours to be used for charting!
Also as a hint to get people thinking, the shape points may reverse engineered and used to draw the same map on an XY chart!
The only thing I ask in return for these items is that if you create anything with them, you share!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
As promised the UK Traditional counties as a set of shapes!
Each County is a seperate shape, so sections can be split off, they are all grouped as its difficult to position them. I also inculded the first map which I overlayed over the counties, this can be removed but it does show the country borders and the isle of man.
Both maps are scale maps, but both the counties map was drawn seperately and by hand, although it is fairly accurate I took some licence to reduce detail! I originally created a countymap using accurate shape files but the redraw time was small!
The second tab has a list of all shapes (there are some of the islands which I dint name!) that I named with the county. I refrained from putting the county names in the counties as text as it gets cluttered, but you could if you wanted!
Enjoy!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Thanks Darren,they're really useful. If I create anything non-confidential I'll be happy to share.
Kind of reviving an older topic here. I was playing with this map today and created a macro to colour code each of the counties based on a set of values. Thank you for creating this map as it could be very powerful in visually represeting data from a variety of sources including Accounting, Marketing, etc.
The coding is still rough but I thought I would share in case anyone else could get some value out of it
GB playground.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks