Show a heat map in 3D Maps

Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021

When you open 3D Maps, your geographic data is displayed on a map and can be visualized using several chart types, including column charts and heat maps. You can switch to a heat map, where colors represent your data, making it easy to identify patterns and concentrations in large amounts of geographic data at a glance.

Screenshot that shows heat map of the middle and eastern US showing energy capacity.

  1. Select Home > Layer Pane.
    Screenshot that shows Layer Pane button on the Power Map Home tab.

  2. In the Layer Pane, select the layer you want to display as a heat map, and then select the Heat Map icon.
    Screenshot that shows Heat Map icon in Layer Pane.

    Note

    • When you switch to a heat map, the Height field changes to Value.
    • Zoom in or rotate the chart to get a better view of the heat map.
    • You can’t add annotations to heat maps.