Create a Bubble Chart with Multiple Series of Data

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.

📝 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!

#excel
#msexcel
#doughexcel

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

[stephenphan]

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

[_Bb_Bb_Bb]

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!

[Mbellelondon]

Is it possible to add a 4 variable. So the I want to add a header to each line of data you have shown. So it will have an additional column which will have words displayed. so each bubble will be a different color to represent each header. Is this possible? Thanks

[MLFranklin]

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.

[taylorhenderson]

Awesome video- very straight forward, easy to follow and exactly what I needed. Thanks!

[vijayamani]

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.

[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!

[topalecom]

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.

[ayeshaa]

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.

[prakashtimes]

Hello. If thee data series is five instead of three as you have shown, which kind of chart do you use for analysis

[AnandKumar-xfro]

Thanks for the videos.. could you guide if I have to apply the same objective in power Bi bubble chart...

[alanwong]

Helpful, very easy to follow and to the point. Thank you very much.

[lionelschotter]

Great instructional video. Do you know the best way to deal with blank rows in a bubble chart?

[keilairizarry]

Thank you. This was very helpful and easy to follow.

[SJQuirke]

thanks for this - as an utter Excel Noob I found it very useful

[thblade]

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).

[adityamore]

F9 is not working in my device whats alternative to that

[gdpdr]

cheers good video - I'd say you go straight to 1:40 (like so more ppl see it) ;)

[adarsh]

pog champ this is very poggers thank you ms morschek

[jammalelamarti]

Thanks for this video. It is realy useful ! Good Job