Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop

Scatter and bubble charts are a great way to display a lot of related data in one chart. In scatter charts, the x-axis displays one numeric field and the y-axis displays another, making it easy to see the relationship between the two values for all the items in the chart.

In a bubble chart, a third numeric field controls the size of the data points.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Create a bubble chart

  1. Create a table with one category value.

    Start with a table to make a scatter chart

    Tip: Pick a category that doesn’t have too many values. If the category has more than 2,000 values, you see a note that the chart is “showing representative sample” rather than all the categories. Really, it’s hard to see individual bubbles if you have a lot of them.

  2. Add two or three numeric values to the table.

    • With two values, you get a scatter chart of little circles, all the same size.

    • With three values, you get bubble chart. Each bubble is a different color and the size of the bubble illustrates the third value.

  3. To convert the table to a chart, on the Design tab:

    • In Power View in Excel, click the arrow under Other Chart and click Scatter.

    • In Power View in SharePoint, click Scatter.

    Power View automatically puts the category in the Details box, and the two numeric values in the X Value and Y Value boxes.

    Convert Power VIew table to a scatter chart

Follow data over time

To view changes in data over time, you can add a time dimension to scatter and bubble charts, with a ‘play’ axis.

  • Select the bubble or scatter chart and drag a field with time values to the Play Axis box.

This adds a ‘play’ button and time line to the bottom of the chart.

When you click the play button, the bubbles travel, grow, and shrink to show how the values change based on the play axis. You can pause at any point to study the data in more detail. When you can click a bubble on the chart, you can see its history in the trail the bubble has followed over time.

Bubble chart with play axis and data labels

Top of Page

Color-based categories for scatter and bubble charts

You can add a field to the Color box for a scatter or bubble chart, and it colors the bubbles or scatter points differently, according to the different values in that field, overriding the bubble colors. For example, adding the Category field to a bubble chart of foods assigns different colors to the bubbles depending on if they are fruits, vegetables, breads, or beverages.

Bubble chart with color series

The field can’t be a calculated field, and can have no more than twenty instances.

Note: You can click a color in the legend to highlight all the bubbles for that color, but that doesn’t show traces for all the bubbles in that color. You have to click each bubble individually to show its trace. You can select more than one bubble at a time by pressing Ctrl + Click.

Notes: Video copyrights:

  • Olympics Dataset © Guardian News & Media Ltd.

  • Flag images courtesy of CIA Factbook (cia.gov)

  • Population data courtesy of UNData (data.un.org ) on Microsoft Azure Marketplace.

  • Olympic Sport Pictograms by Thadius856 and Parutakupiu, distributed according to the license on Wikimedia Commons (creativecommons.org/licenses/by-sa/3.0/)

Top of Page

See Also

Charts and other visualizations in Power View

Sort a chart in Power View

Power View: Explore, visualize, and present your data

Power View and Power Pivot videos

Tutorial: PivotTable data analysis using a Data Model in Excel 2013

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.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×