Change to a bubble chart in Power Map

Power Map shows a column chart by default when you create a map, but you can change that to a bubble chart, where the size of the bubble emphasizes specific data values.

1. Click Home > Layer Pane.

   

2. On the Field List tab, click Bubble.

   

Tip:  You can also change the shape of the bubbles.

When different categories are added for the same data points, the bubbles will automatically resize to show the new ratios, in the same way that slices in a pie chart resize when data series are added. The chart legend will also automatically update.

If there are more categories in a bubble chart, it starts to look like a pie chart, showing each of the categories in a section of the whole pie bubble. To create a pie bubble, add one or more category fields to your bubble chart. In the example below, New York City has five tall buildings, while Chicago only has one. So, there is a bubble for Chicago and a pie for New York City. If you wanted to make Chicago a pie bubble, you would add another building.