Create a Bubble Chart with Multiple Series of Data 

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

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!

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

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

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!

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

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

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.

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.

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.

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

Thanks for the Bubble Chart!

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

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

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

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

F9 is not working in my device whats alternative to that

Thank you so much. It is so helpful.

pog champ this is very poggers thank you ms morschek

what would a bubble chat be used for

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

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

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.

Brilliant! Thanks.

how to calculate Z value at first?

Very helpful...thanks

fantastic!

Really helpful

Thank you

thanks!

Nice video