Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 4 of 4

Help Please!!! With Mapping information to pie charts

This is a discussion on Help Please!!! With Mapping information to pie charts within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello all, I am currently stuck trying to sort out how to sort data for a massive spreadsheet, and I ...

  1. #1
    DCM
    DCM is offline Junior Member White Belt
    Join Date
    Dec 2005
    Posts
    2

    Help Please!!! With Mapping information to pie charts

    Hello all,

    I am currently stuck trying to sort out how to sort data for a massive spreadsheet, and I am stuck. I have:

    1. 160 employees across the USA
    2. 11 Managers
    3. 320+ Clinical Research projects

    My boss wants me to import this into Map Point and show which of the 160 employees are working on which of the 320 plus Clinical Projects!

    The main problem is that the clinical projects have a name and not a number, and when you add up all of the lines in Excel, there are over 14000 lines of data!

    Is this a hard thing to figure out?

    If someone can point me in the right direction, I would appreciate it greatly!

    Thank you again

    DCM

  2. #2
    Dazzer is offline Senior Member Green Belt
    Join Date
    Sep 2003
    Posts
    103
    This is just an idea and I don't know how easy it would be for you to implement as i'm not sure how your data is formated but could you have a spreadsheet that looked something like

    Emp Zip Code | Project ID
    --------------------------------
    ab123 | 1
    bc345 | 2
    de456 | 3

    Then you could import this into mappoint set it to 'multiple symbol' and 'unique values' then for every zip code (row) in your spreadsheet you would have a pin thats color is based on the project ID.

    The project ID would have to be a unique incrementing number, if you don't already have such an ID you could use MS Access to generate one and some queries to fill out the ID for the employees then export back out to excel. (please remember i'm in the UK and have no idea what US zip codes look like! )

  3. #3
    DCM
    DCM is offline Junior Member White Belt
    Join Date
    Dec 2005
    Posts
    2
    Hi Dazzer!

    Thanks a million for the idea! It put into a new direction and so far it is working. I decided to use the pushpins to highlight each CRA and imported the excel data that is important to that persons manager. I have to input the data manually in each balloon, but it gets me through the day!

    Thanks again

    DCM

  4. #4
    Dazzer is offline Senior Member Green Belt
    Join Date
    Sep 2003
    Posts
    103
    Glad I could help, I don't envy you have to enter all that data manually though, good luck.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mapping-Tools.com releases pre-computed US mileage charts
    By Winwaed in forum News and Announcements
    Replies: 1
    Last Post: 11-14-2006, 08:43 AM
  2. Creating Mileage Charts
    By ekrupa in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-30-2004, 09:37 AM
  3. Automatic Bar/Pie Charts (with Data from SQLServer)
    By webjagger in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-27-2004, 11:16 AM
  4. How can I change charts size?
    By julior in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-12-2004, 05:22 AM
  5. Sized Pie Charts - Legend Query
    By stephen kilbee in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-15-2004, 01:20 PM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96