1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.
  1. Joseph Horling

    Joseph Horling Member

    Messages:
    36
    Hi Chandoo Experts,

    I am currently in a chart frenzy mode in excel. I want to learn how to do complex charts and one of them is map charting. In the excel file I have uploaded for you is a map of my home state of Michigan. What I would like to do is chart each city where I have visited, not visited or soon to be visited. I saw a video on this where I have to research the longitude and latitude of each city and put a bubble chart. However my chart didn't come out as I was hoping for and I am stuck. It is in the MAP tab. Just wondering if you all can help on this issue. Thank you . Joe, Michigan.

    Attached Files:

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,066
    Jopseph

    A few issues with what you are doing

    1. Remember that when using lats and Longs these are taken from the mapping of the location on a Sphere, As such representing them on a Planar/Flat projection as a chart can be done in small areas, but will have errors the further North you go

    2. The state of Michigan extends from
    Lat 90W to 82W
    Long 41.5 to 47.5N

    The lats are negative as they are west

    Setup the chart as you have then change the Min/Max to the above values

    Also change you data to have negative Lats

    Voila

    upload_2018-2-10_12-11-38.png

    see attached file

    You may want to tweak the Min and Max a Little bit, but its looking fairly close

    Attached Files:

  3. Joseph Horling

    Joseph Horling Member

    Messages:
    36
    Hey Hui,
    Thanks for providing your expertise. What did I miss when I was doing mine? Was it the negative lats?
  4. Joseph Horling

    Joseph Horling Member

    Messages:
    36
    Sorry to bother you again. One more question: How do I put in the yes, no, or soon answers by the cities that i have visited? Do I put in a separate text box for them or can format the bubble to reflect that?
  5. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,066
    You didn’t scale the axis properly and didn’t allow for negative lays

    Add labels as a Data Labeks to each series
    They can reference a range
    And can update when the data changes
  6. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,066
    To add Been, Soon, Not been you need a series for each
    upload_2018-2-12_8-23-55.png

    see attached file:

    Attached Files:

  7. Joseph Horling

    Joseph Horling Member

    Messages:
    36
    Hi Hui,
    I'm sorry. I was talking about the Power Map that was an add in for excel. It wasn't loading up for me. Anyway, I did like what you did to my Michigan map.
    Thank you.

Share This Page