# How to Plot Points on a Map in Excel: 2 Effective Methods

STEPS:

• Select all cells of the dataset.

• Go to the Insert tab, select 3D Map, and select Open 3D Maps.

• After selecting Open 3D Maps, you will see the map with points in a new window.
• The map is automatically updated because Excel understood the dataset clearly. You can see that from the Location box.

• But if it’s not updated automatically, you must add the latitude and longitude fields.
• Navigate to the Location box and click the plus (+) icon.
• Select Latitude.

• Click on Select One and select Latitude from the drop-down menu.

• After adding Latitude and Longitude, the Location box will look like below.

• The map will look like this. The points of the states are visible on the map.

• Select ‘Change the visualization to Bubble’ and add States in the Category section.

• The points will get bigger and each point will show a different color.

• To resize the points, expand the Layer Options menu.

• Decrease the size of the bubbles using the Size option.

• Your map will look like the screenshot below.

• You can see the information if you place the cursor on a point.

• Turn on the ‘Map Labels‘ option to see the map with the name of the states.

### Method 2 – Use Map Option to Plot Points in Excel

STEPS:

• Select a cell in the dataset and press Ctrl + A. It will select all the used cells in the worksheet.
• Use the mouse to select all cells of your dataset.

• Go to the Insert tab and select Map. It will open a drop-down menu.
• Select the Filled Map icon from there.

• You will see the map on the Excel sheet.

• Change the Chart Title to make the map more understandable.

• Click on the map, and a plus (+) icon will appear.
• Check Data Labels from there.

• Put the cursor at the bottom left point of the map and the cursor will change into a double-headed arrow.
• Expand or resize the map according to your needs.

• You will see the data points of population change on the map.

## Related Articles

<< Go Back to Excel Map ChartExcel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF