excell mapping

Discussion in 'Design and Graphics' started by Aniej, Dec 16, 2006.

  1. macrumors 68000

    Aniej

    Joined:
    Oct 17, 2006
    #1
    anyone know how to show different data level displayed against a map. so if you have a city and you want to show lets say 5 neighborhoods and want to compare the support a candidate has against another candidate in each of those 5 neighborhoods could you do it? I am thinking of something where like either the area is raised or a bar chart comes out or the color is a certain color, I don't know but I am just trying to show more support or less support in different regions. Thanks.
     
  2. macrumors 604

    clayj

    Joined:
    Jan 14, 2005
    Location:
    visiting from downstream
    #2
    Sounds like you need something like Microsoft MapPoint.
     
  3. thread starter macrumors 68000

    Aniej

    Joined:
    Oct 17, 2006
    #3
    Wow, I have heard of many thing, but never that? is it part of office or what?
     
  4. Administrator/Editor

    WildCowboy

    Staff Member

    Joined:
    Jan 20, 2005
    #4
    No...it's a stand-alone app updated yearly. Windows only. North American version is $299.

    More info here.
     
  5. thread starter macrumors 68000

    Aniej

    Joined:
    Oct 17, 2006
    #5
    Yeah i just checked it out and discovered it is windows only also. Wildcowboy, any ideas on what to do? It doesn't even have to be a real map, as in it can be just a 2D outline of certain political boundaries with a 3D color representation of each candidate's support? The map part really just needs to be the most basic possible for example:
     

    Attached Files:

  6. macrumors 68030

    cr2sh

    Joined:
    May 28, 2002
    Location:
    downtown
    #6
    There might be a bit of a learning curve.. but you could do what you're asking with an open-source GIS program like GRASS or QuantumGIS.

    It looks to me that the map you just posted was made in arcview (guessing from the north arrow.) I'm not sure if you'd be abe to get your hands on the shapefiles or not.. but that'd make the task at hand very easy.
     
  7. thread starter macrumors 68000

    Aniej

    Joined:
    Oct 17, 2006
    #7
    beleive it or not I have ArcGIS 9, would that make this a lot easier?
     
  8. macrumors 68030

    cr2sh

    Joined:
    May 28, 2002
    Location:
    downtown
    #8
    I was operating under the assumptions that you were a novice and a mac user. Apparently neither of those two are true? Is the map above the one you want to change? Do you have it's data sources?

    Is the data geocoded already? What does the data table look like?

    If it really is as simple as 5 communities and wanting to display their political preference.. I might just grab a map from google and using photoshop replace the background colors to represent the data.
     
  9. thread starter macrumors 68000

    Aniej

    Joined:
    Oct 17, 2006
    #9
    I am most certainly a Mac user, but have had to resort to me Dell when working on GIS related matters, which is why I was asking about Apple specific geocoding software. I am also not a newbie.

    Yes the map above is the one I was looking a changing or I might just redo it entirely myself instead of trying to get my hands on the shape files.

    Any more thoughts on how to go from here?


     
  10. macrumors 6502

    Mydriasis

    Joined:
    Mar 17, 2005
    #10
    If its just about drawing an image why not use illustrator, photoshop or anything that does graphs. (I dont understand much about cartography)

    If you want to make something 3d quick and easy you could try quartz and make the program yourself.

    Here I whipped this up in like 35min with zero lines of code. (well there is a little javascript in there but I stole that from something else i had).

    I know you probably need a real program but if you like I can send you the qz file I used.

    EDIT: here is a picture of what the program looks like with content.
     

    Attached Files:

  11. thread starter macrumors 68000

    Aniej

    Joined:
    Oct 17, 2006
    #11
    That is a great rough sketch and shows how I could further develop it into a representative graphic. I would really appreciate it if you would send me the qz files as you offered. Thanks, this is a great step in the right direction.
     
  12. macrumors 6502

    Mydriasis

    Joined:
    Mar 17, 2005

Share This Page