Create a Bubble Chart with Multiple Series of Data
HTML-код
- Опубликовано: 15 июл 2024
- Ask kids if they like bubbles and most likely you'll get a resounding "YES!" Heck even some adults like bubbles. I think it has something to do with the shiny curves and the airiness of these spherical entities. So when you have the chance to add more bubbles to your Excel bubble chart why not? Think of it as a fancy X Y scatter chart with similar variables that you'll plot with the exception of the value that affect the size. The techniques used to create a bubble chart can also be used to make a perceptual map for those of you marketers out there. If you wanted to create motion or an animated bubble chart go to • Bring Your Data to Lif... . This is similar to the Hans Rosling TED talk he did and what you'll see on the gapminder website.
Anyways back to the bubbles...it's actually not that hard to add more more series of data to your chart. But be careful of adding too many series (bubbles), because just like a washing machine overloaded with too much detergent, a bubble chart can be overloaded with too many bubble.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~
A quick and sort lesson but give us powerful insights into applying to Excel. Thanks to Doug!
Everytime I need an instant advise for any topic my mind come across to your lessons right away
Hi Stephen Phan, thanks for the kind words!
Thanks for the Bubble Chart!
You're welcome!
Awesome video- very straight forward, easy to follow and exactly what I needed. Thanks!
Hi taylor henderson, glad you liked it, thanks for commenting! If you like to see a bubble chart animate over time. See ruclips.net/video/5jWWA-lvfQM/видео.html
Helpful, very easy to follow and to the point. Thank you very much.
Glad it was helpful!
I was struggling with the bubble sizes, and I realized that I didn't consider I should've put Z colum data as well.
So useful clip, thx!
You're welcome!
Very helpful. Clearly explained and quick to get to the point. Following it proved to me that the feature does actually work. It helped me troubleshoot one of my charts. The x-axis was not working correctly and would show up as data point number rather than the x value. It turns out that Excel reverts to point number on the x-axis if there are any non-numerical values in the column.
Hi Lack of Focus, thanks for the comment!
how do we create the chart from a datasheet, in this example you have a group of nombres already , is it possible to pull the data from a list that is categorized instead of generating random data.
yep, that is possible
thanks for this - as an utter Excel Noob I found it very useful
Hi Stephen Quirke, glad you liked it, thanks for commenting!
Thanks for this video. It is realy useful ! Good Job
Hi Jammale Lamarti, thanks for the comment!
Thank you. This was very helpful and easy to follow.
Hi Keila Irizarry...you're welcome, glad you liked!
Brilliant! Thanks.
Thanks Dudley Gentles!
Hi thanks for the video. I have a question. How to draw a line chart over this bubble chart. X axis values will be same but y axis values will be different for the line chart. Thanks in advance.
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!
Very helpful...thanks
You're Welcome!
pog champ this is very poggers thank you ms morschek
Hey, do you know of any way we can add lines (connecting two points) in the bubble chart. It can be done with the x,y scatter chart. But i need the weight (which is only available in the bubble chart).
maybe this will give ideas ruclips.net/video/bYf6qO-iBW0/видео.html
fantastic!
Hi Fred Darko, thanks for the comment!
Thank you so much. It is so helpful.
You’re welcome!!
I was STRUGGLING wondering why my bubbles for Series1 wasn't appearing and found your video and immediately found the answer. (I hadn't declared the size of the bubbles). I want to cry - I spent way too much time trying to figure this out lo.
Thanks @ayeshaa4781, glad it helped!
Great instructional video. Do you know the best way to deal with blank rows in a bubble chart?
Have you tried putting #N/A in place of blanks?
Hello. If thee data series is five instead of three as you have shown, which kind of chart do you use for analysis
Five is getting up there for a scatter. Maybe panel charts?
ruclips.net/user/dough517search?view_as=subscriber&query=panel
Thanks for the videos.. could you guide if I have to apply the same objective in power Bi bubble chart...
Yes, you probably can. In Excel it's the power view feature seen the vid link below, but i think this could be translated to Power BI ruclips.net/video/5jWWA-lvfQM/видео.html
@@DougHExcel Thanks for quick reply..I tried ur suggestion but its not working...Let me explain in details...I have excel data set from which i need to create two bubble chart in one visual...it include two column with probability on it.then 4 more column with measure or fact in it... similar objective explained in ur excel...
Really helpful
Hi ziyi zhou, glad you liked it, thanks for commenting!
what would a bubble chat be used for
Very easily understandable format for CXOs and BoD members. E.g., comparison of all the major restaurant franchisors in Americas comparing their revenue growth (Y axis), EBITA margin (X axis) and Revenue (bubble size). One can then easily see which are the big companies, highly profitable and growing fast.
Hi Robert Jean-Louis, thanks for the comment!
Thank you
You're Welcome!
cheers good video - I'd say you go straight to 1:40 (like so more ppl see it) ;)
Hi +Pedro Montano, thanks for the comment!
Hi +Pedro Montano, glad you liked it, thanks for commenting!
Nice video
Thanks for the comment!
thanks!
Welcome!
how to calculate Z value at first?
Hi nira khatiwada, thanks for the comment, z value depends on the data source
F9 is not working in my device whats alternative to that
In the Ribbon, Formula >> Calculate Now
What is the point of bubbles with no label to explain what they represent? This example is a little worthless, because each data point would typically have a name associated. This does not show how to represent that on your chart.
Lee Melbourne, that is very interesting...thanks for letting me know.