How To Create A Bubble Plot In Excel (With Labels!)
HTML-код
- Опубликовано: 3 июл 2024
- 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
www.datawrapper.de/charts/sca...
www.gapminder.org/data/
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)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
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. Хобби
Thank you so much, I'm already 55 and I had never been able to darw oine of these graphs, Greetings from Chile!!!!
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!
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 👏🏾
Thanks so much. Very simple and easy to follow. Just what i needed.
Great tutorial, the clearest I've watched regarding bubble charts in Excel. Thank you so much!
Cheers for the feedback mate!
It was easy to understand. Thank you so much
Helped me tons, I was really struggling before your video, thank you.
This was very helpful. thank you!
Super helpful! Thank you!
Thank you, this was extremely helpful.
Awesome! you helped me a lot today!!!
Thanks, this has been driving me nuts.
Excellent. Helped a lot :)
Nice video and nice that on the chart has appeared my country ;-) Thank you.
Thanks man
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
Thanks !
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)
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
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!
can i prepare a bubble chart for International / national Brand having turnover for Infra and Building separately?
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)
Is there an automated option to color the bubbles?
Yes, just filter the table by continent. Then create separte series for every continent. The advanage in this case is that you can view the different colours as a legend
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