Show a heat map in 3D Maps

Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

When you open 3D Maps, Bing Maps automatically plots your data in a column chart. You can change to a heat map, where colors represent your data, making it easy for people to take in lots of data at a quick glance.

Heat map of the middle and eastern US showing energy capacity

  1. Click Home >Layer Pane.
    Layer Pane button on the Power Map Home tab

  2. In the Layer Pane, in the layer that you want to display as a heat map, click the Heat Map icon.
    Heat Map icon in Layer Pane

    Note

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