Forum Discussion

Shirley2727's avatar
Shirley2727
Copper Contributor
Oct 18, 2021

Issue with 2D Map in Excel

Hello, I have a problem with 2D Map, i want to create a Map Chart with all the states in Brasil but when i get the map, the map shows all states less Pará.

Could you please help me?

1 Reply

  • PedroWave's avatar
    PedroWave
    Brass Contributor

    Shirley2727, in the attached file I have created a table with geographic information of the states of Brazil.

     

    With the cells in column A selected, go to the Data tab and then click Geography.

    This link explains how to do it: https://support.microsoft.com/en-us/office/get-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00f45dbbd6 

     

    Regards.

    Pedro Wave