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

After plotting your geography data in 3D Maps, you can use the Layer Pane to change the look and feel of your data on the map. By default, 3D Maps shows a column chart, but you can show a bubble chart, region chart, or heat map instead.

Column chart in Power Map

Here’s an example of a region chart that shows voting preferences by county for the major political parties in the United States. The deeper the red or the blue color, the higher the percentage by which a particular party leads in an election.

Region chart in Power Map

Here’s how to change the way your data is visualized:

  1. If you don’t see the Layer Pane, click Home > Layer Pane.

    Task Pane button on the Home tab

  2. For the layer where you want to show additional data, in the Add Field drop-down list under Location, click the type of data that you want to show.

    (You can add more than one type of data.)

    Add Location on Layer Pane

    Tip: The fields that appear in this list will vary depending on the data that is available.

  3. To change the type of chart that is displayed, click any of the available types: Stacked Column, Clustered Column, Bubble, Heat Map, or Region.

    Chart types in the Type box

Notes: 

  • When you apply a heat map, the Height or Size box changes to a Value box. You can change the way value fields are aggregated, by clicking the arrow in the Value box and picking the function that you want. Typically, Sum is applied by default, but you can pick Average, Count, Max, Min, or None. You can also remove a value field from the Value box.

  • If you drag a field to the Category box and leave the Height box blank, 3D Maps automatically adds that field to the Height box and draws a visual that represents the count of each category.

  • Instead of dragging fields into the Height and Category boxes, you can just check the field boxes. 3D Maps puts those fields in the appropriate box.

Learn more about chart types and shapes

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.