How to Use Excel Power Map for 3D Geographic Visualizations

When presenting regional sales data, a standard bar chart or pie chart is often inadequate. If you have a spreadsheet containing thousands of rows of sales data, complete with customer addresses, zip codes, or city names, summarizing it in a standard 2D PivotTable hides the geographic relationships. To truly impress stakeholders and reveal regional trends (e.g., “Why are sales booming in coastal cities but failing inland?”), you need to visualize the data on a real map. You don’t need expensive GIS software to do this; Microsoft has built a powerful 3D geospatial visualization engine directly into Excel called Power Map (officially rebranded as 3D Maps).

Step 1: Prepare Your Data

Power Map is incredibly smart, but it requires structured data. You must format your raw data as an official Excel Table (select the data and press Ctrl + T).

Your table must contain at least two types of columns:

1. Geographic Data: At least one column containing a Country, State, City, Zip Code, or exact Latitude/Longitude coordinates. (You do not need all of them; just Zip Codes are enough).
2. Value Data: At least one column containing a number you want to analyze (e.g., Sales Revenue, Profit Margin, Population).

Step 2: Launch 3D Maps

With your cursor clicked anywhere inside your formatted data table:

1. Navigate to the Insert tab on the Excel ribbon.
2. In the “Tours” group, click the 3D Map button. (In older versions of Excel, you may need to enable the Power Map COM Add-in first via File > Options > Add-ins).
3. A completely new window will launch, displaying a 3D globe. Your data is being sent to Bing Maps in the background to geocode (translate your text into coordinates).

Step 3: Map the Geography

Look at the “Layer Pane” on the right side of the screen. Power Map usually auto-detects your geographic columns.

• If you have a column named “City”, ensure the dropdown next to it in the “Location” box is set to City.
• If Excel mapped it incorrectly, change the dropdown so Bing Maps knows how to interpret the text.

You will instantly see dots or small columns appear on the 3D globe representing your data points.

Step 4: Visualize the Values

Now you need to give the data meaning.

1. In the Layer Pane, find the Height box.
2. Click Add Field and select your value column (e.g., “Total Revenue”).
3. The dots on your map will instantly transform into 3D columns. A towering column in New York means high revenue; a flat column in Kansas means low revenue.

To add more depth, find the Category box and add a dimension (e.g., “Product Type”). The 3D columns will now become stacked bar charts, color-coded by the type of product sold in that specific city.

Step 5: Change the Visualization Type

Sometimes 3D columns are too cluttered if you have thousands of data points packed tightly together. At the top of the Layer Pane, you can change the visualization style:

• Heat Map: The absolute best way to visualize density. It turns the data into a glowing aura (red for high concentration, blue for low), making regional hotspots immediately obvious.
• Region (Choropleth): If you are using State or Country data, this will color in the entire borders of the state based on the value, rather than putting a column in the middle of it.

Step 6: Add the Dimension of Time

This is Power Map’s most impressive feature. If your data table has a “Date” column, you can drag that field into the Time box in the Layer Pane.

A timeline slider will appear at the bottom of the screen. When you click the Play button, Power Map will animate the globe, showing the 3D columns growing or the Heat Map spreading across the country chronologically. You can visually watch your sales expand from the East Coast to the West Coast over a 12-month period.

Step 7: Exporting the Visualization

You cannot easily embed the interactive 3D globe back into your flat spreadsheet. Instead, Power Map is designed to export presentations.

1. Click the Create Video button in the ribbon.
2. Choose your resolution (1080p for presentations).
3. Excel will render an MP4 video of your animated time-lapse or your manual panning and zooming around the globe, which you can drop directly into a PowerPoint slide to stun your audience.