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
@DougHExcel
5 жыл бұрын
Hi Stephen Phan, thanks for the kind words!
@1696_Bb_Bb_Bb
3 жыл бұрын
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!
@DougHExcel
3 жыл бұрын
You're welcome!
@MLFranklin
6 жыл бұрын
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.
@DougHExcel
6 жыл бұрын
Hi Lack of Focus, thanks for the comment!
@LibertyDogRecsue
Ай бұрын
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
@excelisfun
8 жыл бұрын
Thanks for the Bubble Chart!
@DougHExcel
8 жыл бұрын
You're welcome!
@alanwong8307
4 жыл бұрын
Helpful, very easy to follow and to the point. Thank you very much.
@DougHExcel
4 жыл бұрын
Glad it was helpful!
@keilairizarry8469
4 жыл бұрын
Thank you. This was very helpful and easy to follow.
@DougHExcel
4 жыл бұрын
Hi Keila Irizarry...you're welcome, glad you liked!
@1adarsh269
2 жыл бұрын
pog champ this is very poggers thank you ms morschek
@marijadzincic2408
Жыл бұрын
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!
@vijayamani1987
3 жыл бұрын
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.
@jammalelamarti6467
6 жыл бұрын
Thanks for this video. It is realy useful ! Good Job
@DougHExcel
6 жыл бұрын
Hi Jammale Lamarti, thanks for the comment!
@lionelschotter4914
3 жыл бұрын
Great instructional video. Do you know the best way to deal with blank rows in a bubble chart?
@DougHExcel
3 жыл бұрын
Have you tried putting #N/A in place of blanks?
@adityamore2608
2 жыл бұрын
F9 is not working in my device whats alternative to that
@DougHExcel
2 жыл бұрын
In the Ribbon, Formula >> Calculate Now
@dudleygentles7056
6 жыл бұрын
Brilliant! Thanks.
@DougHExcel
6 жыл бұрын
Thanks Dudley Gentles!
@AnandKumar-xf3ro
4 жыл бұрын
Thanks for the videos.. could you guide if I have to apply the same objective in power Bi bubble chart...
@DougHExcel
4 жыл бұрын
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 kzitem.info/news/bejne/lqCNvXVjpaiXhII
@AnandKumar-xf3ro
4 жыл бұрын
@@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...
@lakshmikannan4398
6 жыл бұрын
Very helpful...thanks
@DougHExcel
6 жыл бұрын
You're Welcome!
@g0dp3dr0
5 жыл бұрын
cheers good video - I'd say you go straight to 1:40 (like so more ppl see it) ;)
@DougHExcel
5 жыл бұрын
Hi +Pedro Montano, thanks for the comment!
@DougHExcel
5 жыл бұрын
Hi +Pedro Montano, glad you liked it, thanks for commenting!
@Lordblanca
8 жыл бұрын
what would a bubble chat be used for
@inaspot
5 жыл бұрын
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.
@DougHExcel
4 жыл бұрын
Hi Robert Jean-Louis, thanks for the comment!
@ziyizhou2501
5 жыл бұрын
Really helpful
@DougHExcel
5 жыл бұрын
Hi ziyi zhou, glad you liked it, thanks for commenting!
@ayeshaa4781
Жыл бұрын
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.
@DougHExcel
Жыл бұрын
Thanks @ayeshaa4781, glad it helped!
@fdarko1
6 жыл бұрын
fantastic!
@DougHExcel
6 жыл бұрын
Hi Fred Darko, thanks for the comment!
@TheBchhi
3 жыл бұрын
thanks!
@DougHExcel
3 жыл бұрын
Welcome!
@asmaagilliland8189
5 жыл бұрын
Thank you
@DougHExcel
5 жыл бұрын
You're Welcome!
@leemelbourne3297
3 жыл бұрын
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.
@DougHExcel
3 жыл бұрын
Lee Melbourne, that is very interesting...thanks for letting me know.
@nirakhatiwada78
7 жыл бұрын
how to calculate Z value at first?
@DougHExcel
4 жыл бұрын
Hi nira khatiwada, thanks for the comment, z value depends on the data source
@ghurandash6860
8 жыл бұрын
Nice video
@DougHExcel
8 жыл бұрын
Thanks for the comment!
@topalecom
6 жыл бұрын
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.
@DougHExcel
4 жыл бұрын
yep, that is possible
@taylorhenderson8123
4 жыл бұрын
Awesome video- very straight forward, easy to follow and exactly what I needed. Thanks!
@DougHExcel
4 жыл бұрын
Hi taylor henderson, glad you liked it, thanks for commenting! If you like to see a bubble chart animate over time. See kzitem.info/news/bejne/lqCNvXVjpaiXhII
@prakashtimes
4 жыл бұрын
Hello. If thee data series is five instead of three as you have shown, which kind of chart do you use for analysis
@DougHExcel
4 жыл бұрын
Five is getting up there for a scatter. Maybe panel charts? kzitem.infosearch?view_as=subscriber&query=panel
@charlottezhang7203
2 жыл бұрын
Thank you so much. It is so helpful.
@DougHExcel
2 жыл бұрын
You’re welcome!!
@4thblade273
6 жыл бұрын
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).
@DougHExcel
4 жыл бұрын
maybe this will give ideas kzitem.info/news/bejne/w4-cnKWFZptzimU
@SJQuirke
6 жыл бұрын
thanks for this - as an utter Excel Noob I found it very useful
@DougHExcel
6 жыл бұрын
Hi Stephen Quirke, glad you liked it, thanks for commenting!
Пікірлер: 66