Change to a bubble chart in Power Map

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

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.

Example of a bubble chart

  1. Click Home > Layer Pane.

    Layer Pane button on the Power Map Home tab

  2. On the Field List tab, click Bubble.

    Bubble icon on the Field List tab

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.

Bubble chart showing a pie chart for New York City and a bubble for Chicago

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.