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
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!
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
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!
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)
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
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)
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!
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 👏🏾
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
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
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!
Thank you so much, I'm already 55 and I had never been able to darw oine of these graphs, Greetings from Chile!!!!
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
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!
Great tutorial, the clearest I've watched regarding bubble charts in Excel. Thank you so much!
Cheers for the feedback mate!
Hi Steve, Do you know how to add the unit of measurement like (k$) or MT beside the value in the labels?
can i prepare a bubble chart for International / national Brand having turnover for Infra and Building separately?
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!
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)
Thanks so much. Very simple and easy to follow. Just what i needed.
Awesome! you helped me a lot today!!!
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
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)
Helped me tons, I was really struggling before your video, thank you.
Thank you, this was extremely helpful.
Nice video and nice that on the chart has appeared my country ;-) Thank you.
This was very helpful. thank you!
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!
Thanks, this has been driving me nuts.
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 👏🏾
It was easy to understand. Thank you so much
Super helpful! Thank you!
super helpful, thanks!
Thanks man
Thanks !
Excellent. Helped a lot :)
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