+ Reply to Thread
Results 1 to 6 of 6

Thread: Another Frebie Shape Map of the UK

  1. #1
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,006

    Another Frebie Shape Map of the UK

    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!
    Attached Files Attached Files
    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!


  2. #2
    Forum Guru, retired Admin royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    25,647

    Re: Another Frebie Shape Map of the UK

    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)

  3. #3
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,006

    Re: Another Frebie Shape Map of the UK

    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!


  4. #4
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,006

    Re: Another Frebie Shape Map of the UK

    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!
    Attached Files Attached Files
    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!


  5. #5
    Registered User
    Join Date
    08-25-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2003
    Posts
    46

    Re: Another Frebie Shape Map of the UK

    Thanks Darren,they're really useful. If I create anything non-confidential I'll be happy to share.

  6. #6
    Registered User
    Join Date
    11-02-2011
    Location
    Lake Echo, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Another Frebie Shape Map of the UK

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0