I’ve had some fun today learning this new feature of Microsoft Office 2016 — the ability to make bubble diagrams. Bubble diagrams are basically a way to plot out information points with three sets of values. The first two values in the set are plotted on the x and y axes of the chart. The third value determines the size of the bubble. If you would like to learn more about bubble charts, click here to see a Wikipedia article.
Why Bubbles?
Most charts in Office reflect two values of data. For example, sales amount in dollars per month; number of subscriptions per country; and so on. Bar charts and line charts do a fine job of illustrating those. But, what if you have a third value that goes with each pair? For example, let’s say you have dollars in sales, number of subscriptions, and square miles of sales territory represented by the sale? And what if those square miles of coverage are a major data point that you need to convey in your document or presentation? That is where a bubble chart comes in. The POSITION of the bubble reflects your first two data points. The SIZE of the bubble reflects the third data point.
How to Set It Up
Bubble charts are a little hidden in MS Office. Technically, they are a kind of scatter chart, and that is where you will find the bubble charts in the Insert Chart dialog.
1. Go to Insert Tab, click Chart, and select X Y (Scatter), and on the top right click on the bubble diagram icon. When you have the right choices selected, the dialog should look like this:
2. Click OK.
3. Word will show the diagram in your document with some dummy data filled in a spreadsheet. Modify this data to contain your own. You will see the bubble diagram update live as you update your numbers.
4. Click the X in the top right of the data window to close it.
5. Now you can format the bubbles and labels. Click the plus (+) icon next to the diagram.
6. Check the box for Axis titles. Note here that Word does not pick out the column titles from your data sheet. You have to type them in. Format them as you wish, by double clicking on the axis title.
7. I find it helpful to show a number in the bubble to reflect its numerical value. It takes a little bit of massaging of the labels to get this to work, though! If you simply check the box next to Data Labels, Word places the value in your data sheet’s second column inside the bubble. Visually, you expect that value to be the one in the third column, which is the one that determines the size of the bubble. There is a workaround. Click the plus (+) icon. Check Data Labels, then click the right arrow next to Data Labels to open another context menu. In the second menu, select Data Callout.
8. You will see all three values next to each bubble now. For each one, double click the label and simply delete the first two values. A bit of a pain, but it works.
9. If you would like to change the color, click the Paintbrush icon, then click the color tab in the menu that appears to the right. Click the color you want to use from the available selections. For the multicolor palettes, Word uses the color that shows on the left (first square) of the palette.
10. If you need to edit the data, right click the diagram and click Edit Data.
Bubble Diagram Limitations in MS Office
There are a few things to remember when creating and editing bubble diagrams in MS Office:
- Bubble diagrams will not render correctly with less than 3 rows of data values.
- You must have exactly 3 columns of data. If you add a 4th column, Word just creates another set of bubbles on the diagram to reflect the size values of the 4th column, with no visual correlation to the rest of the data.
- Do not remove columns and add columns to the data sheet. Type into it as is. The bubbles get really funky if you start moving columns around.
Let me know in the comments how you are using Bubble diagrams in your presentations and documents. I reply to all comments and questions!