How To Create A Bubble Plot In Excel (With Labels!)

In this tutorial, I will show you how to create a bubble plot in Microsoft Excel. A bubble plot is a type of scatter plot where two variables are plotted against each other, with a third variable being used to signify the size of the dots, known as bubbles in this case

DARA SOURCES

VIDEO CHAPTERS
00:00 Intro
00:07 What is a bubble plot?
00:42 Example data
01:29 How to create a bubble plot
02:00 Adjusting the axes
03:22 Adjusting the bubble sizes
04:08 Adding data labels
05:17 Changing the bubble appearance
06:00 Changing the axes appearance
06:36 Wrapping up

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Software (Microsoft Excel 365 ProPlus)

FOLLOW US

AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[globaltomasso]

Thank you so much, I'm already 55 and I had never been able to darw oine of these graphs, Greetings from Chile!!!!

[johntamplin]

At the start, I thought this was going to be an eye-roller (not good) but I'm happy to acknowledge that the content and presentation was very good. I especially appreciate the "I'll do the rest of these off-camera, so I don't waste your time"! 5-stars for that point!

[tayete]

Great tutorial, the clearest I've watched regarding bubble charts in Excel. Thank you so much!

[jpschlosser]

Helped me tons, I was really struggling before your video, thank you.

[misterwill]

Thank you. This will be a new skill. I also like how you showed how to quickly add labels from the original data and that there are options on where to put it 👏🏾

[Elevenbells]

Thanks, this has been driving me nuts.

[stephensandor]

Thanks so much. Very simple and easy to follow. Just what i needed.

[abirkhechiba]

Thank you very much for your vedios it is very useful for phd students and researchers so keep going.please can you make a vedio about sensitive analysis and the tornado diagram

[rachaelnjoki]

Thank you, this was extremely helpful.

[mojahidulislam]

It was easy to understand. Thank you so much

[fajnefajne]

Nice video and nice that on the chart has appeared my country ;-) Thank you.

[jancyxu]

so there is no way to automatically generate colors of the bubble based on the continent? imagine if there are 200 countries you will have to do a lot of manual work and it is really not that smart

[MeghaJar]

Hi Steve, Do you know how to add the unit of measurement like (k$) or MT beside the value in the labels?

[BimanChGhosh]

can i prepare a bubble chart for International / national Brand having turnover for Infra and Building separately?

[dipereira]

Its amazing, even thou i own my carrer to excel Im flabbergasted by how bad it can be... All I want was be able to put the mouse over the dot and see the label, yet its not possible (it is in PowerBI)

[georgelove]

Hi there thanks for this! Would you know how to change the country name to an image instead (i.e the flag). Tried doing a macro for it but was getting too complicated

[mrfish]

Thanks - very helpful. Is there a way to set the colour based on the data - e.g. if there are two continents, each bubble is coloured based on the continent data (not manually set)

[marijadzincic]

Hello, is it possible to make bubbles interactive - for example to get the list of what a bubble refers to as you do when you click on a count in a pivot and it opens a new sheet with items that go into that count? Thanks a lot!

[vanessarieger]

Is there an automated option to color the bubbles?