Plotting X, Y Coordinates on a Map using Microsoft Excel

In most geographic and GIS conventions, X represents longitude and Y represents latitude. Excel’s 3D Maps tool (formerly known as Power Map) lets you plot latitude and longitude coordinates directly on an interactive globe, making it straightforward to visualize location data without any additional software. The steps below use a US airports dataset as a worked example, but the workflow applies to any dataset containing latitude and longitude columns.

Step 1: Prepare Your Data

Start by downloading a dataset that contains latitude and longitude values. For this tutorial, we will use a dataset of airports in the United States, which includes the IATA code, airport name, city, state, country, and the corresponding latitude and longitude coordinates. Convert the data into a formal Excel table by selecting the entire data range and choosing Home > Format as Table. Formatting as a table ensures that 3D Maps can detect the column headers automatically.

Step 2: Open 3D Maps

Navigate to the Insert tab in Excel and select 3D Maps, then click Open 3D Maps. This launches the 3D Maps window, which displays an interactive globe powered by Bing Maps where you can visualize your data geographically.

Step 3: Explore the 3D Maps Interface

Take a moment to familiarize yourself with the 3D Maps interface. You can navigate around the globe using the navigation buttons or your mouse scroll wheel. The map is powered by Bing Maps, giving you a geographic backdrop for your data.

Step 4: Configure the Layers Panel

In the Layer pane on the right, click Add Field under the Location section and select your Latitude column, then repeat for the Longitude column. Make sure each field is assigned the correct role — Latitude for Y values and Longitude for X values — so that Excel plots the points accurately on the map.

Step 5: Plot the Data

Once the Latitude and Longitude fields are mapped, Excel immediately plots points on the globe at the geographic locations of each airport. Adjust the zoom level and camera angle to see the full distribution of airports across the United States.

Step 6: Customize the Visualization

To enhance the visual representation, change the chart type from the default Clustered Column to Bubble using the visualization type buttons in the Layer pane. Adjust the size and opacity of the bubbles to make individual points easier to read. You can also color-code the points by a categorical field — for example, coloring each bubble by state — to highlight geographic patterns.

Step 7: Add Informative Data Cards

Customize the information displayed when you hover over a point on the map. In the Layer pane, add fields such as the airport name and state to the data card section. This allows viewers to see meaningful details about each location without cluttering the map itself.

Step 8: Categorize Points

To differentiate points based on specific characteristics, use the Category field in the Layer pane to color-code points by state. This makes it easy to visually distinguish airports belonging to different states at a glance.

Step 9: Final Adjustments

Make any final adjustments to the map, such as tilting the camera angle or increasing the point size to make individual locations more visible. Once you are satisfied with the layout, the visualization is ready to present or capture as a screenshot directly from the 3D Maps window.

Frequently Asked Questions

• Can I use other datasets? Yes, any dataset containing latitude and longitude columns will work. Simply format it as a table and follow the same steps.
• Do I need to install any additional software? No. 3D Maps is built into Excel 2016 and later versions for Windows. Note that 3D Maps is not currently available in Excel for Mac.
• Can I customize the map further? Yes. Excel offers several visualization types (Clustered Column, Bubble, Heat Map, and Region), as well as options for colors, opacity, and data card content.
• What is the difference between X, Y coordinates and latitude and longitude? In standard geographic convention, X corresponds to longitude (east–west position) and Y corresponds to latitude (north–south position). When setting up your data in 3D Maps, make sure your longitude column is mapped to the Longitude field and your latitude column is mapped to the Latitude field.