At the start, I thought this was going to be an eye-roller (not good) but I'm happy to acknowledge that the content and presentation was very good. I especially appreciate the "I'll do the rest of these off-camera, so I don't waste your time"! 5-stars for that point!
Excellent video, covers everything that's needed without any fluff. I had to create a bubble chart at a pretty short notice and this saved me. Thanks a ton!
Thank you. This will be a new skill. I also like how you showed how to quickly add labels from the original data and that there are options on where to put it 👏🏾
Thank you very much for your vedios it is very useful for phd students and researchers so keep going.please can you make a vedio about sensitive analysis and the tornado diagram
Thanks - very helpful. Is there a way to set the colour based on the data - e.g. if there are two continents, each bubble is coloured based on the continent data (not manually set)
Hi there thanks for this! Would you know how to change the country name to an image instead (i.e the flag). Tried doing a macro for it but was getting too complicated
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!
so there is no way to automatically generate colors of the bubble based on the continent? imagine if there are 200 countries you will have to do a lot of manual work and it is really not that smart
Its amazing, even thou i own my carrer to excel Im flabbergasted by how bad it can be... All I want was be able to put the mouse over the dot and see the label, yet its not possible (it is in PowerBI)
Yes, just filter the table by continent. Then create separte series for every continent. The advanage in this case is that you can view the different colours as a legend
At the start, I thought this was going to be an eye-roller (not good) but I'm happy to acknowledge that the content and presentation was very good. I especially appreciate the "I'll do the rest of these off-camera, so I don't waste your time"! 5-stars for that point!
Great tutorial, the clearest I've watched regarding bubble charts in Excel. Thank you so much!
Cheers for the feedback mate!
Excellent video, covers everything that's needed without any fluff. I had to create a bubble chart at a pretty short notice and this saved me. Thanks a ton!
this tutorial extremely success in helping me finishing my job that i had been struggling for two days. thank you so much!
Thank you, this was extremely helpful.
Thank you so much, I'm already 55 and I had never been able to darw oine of these graphs, Greetings from Chile!!!!
Thanks so much. Very simple and easy to follow. Just what i needed.
It was easy to understand. Thank you so much
Helped me tons, I was really struggling before your video, thank you.
Awesome! you helped me a lot today!!!
Thank you. This will be a new skill. I also like how you showed how to quickly add labels from the original data and that there are options on where to put it 👏🏾
Super helpful! Thank you!
This was very helpful. thank you!
Thanks, this has been driving me nuts.
super helpful, thanks!
Use the formula sign (=) and a text in a cell for addimg the axes' (and chart's) titles. It's much easier to change them if needed.
Thank you very much for your vedios it is very useful for phd students and researchers so keep going.please can you make a vedio about sensitive analysis and the tornado diagram
Nice video and nice that on the chart has appeared my country ;-) Thank you.
the only tutorial I need; How can I resolve overlapping labels when they have the same value?
Excellent. Helped a lot :)
Thank you, great tutorial! Just a question, how to color the bubbles according to the continent? I'm missing this passage in the video... Thanks!
Hi Steve, Do you know how to add the unit of measurement like (k$) or MT beside the value in the labels?
Thanks - very helpful. Is there a way to set the colour based on the data - e.g. if there are two continents, each bubble is coloured based on the continent data (not manually set)
Hi there thanks for this! Would you know how to change the country name to an image instead (i.e the flag). Tried doing a macro for it but was getting too complicated
can i prepare a bubble chart for International / national Brand having turnover for Infra and Building separately?
Thanks man
Thanks !
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!
so there is no way to automatically generate colors of the bubble based on the continent? imagine if there are 200 countries you will have to do a lot of manual work and it is really not that smart
Its amazing, even thou i own my carrer to excel Im flabbergasted by how bad it can be... All I want was be able to put the mouse over the dot and see the label, yet its not possible (it is in PowerBI)
Is there an automated option to color the bubbles?
Yes, just filter the table by continent. Then create separte series for every continent. The advanage in this case is that you can view the different colours as a legend