Create a Bubble Chart with Multiple Series of Data
Doug H Doug H
77.8K subscribers
319,491 views
0

 Published On Sep 3, 2016

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 Life: How to Creat...  . 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 ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://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 https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~

show more

Share/Embed