Balloon Chart in Excel

[@grijalvaescobedo158]

excelente todo lo que haces saludoss desde León Guanajuato México 🇲🇽🤝

[@PKAnExcelExpert]

Gracias por sus valiosos comentarios.

[@jessijuniper7687]

Thank you for this. I got a really big job because of your videos!! :)

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share it with your friends and colleagues whoever is looking for excel and vba tutorials.

[@manivannan6068]

Thanks

[@PKAnExcelExpert]

Thanks for your support

[@a2mtechnicalwissen54]

You are very great sir Your all video are very helpful

[@PKAnExcelExpert]

Thanks and welcome

[@RJG-Studios]

This is really a very nice and simple one to make. I am well aware of Excel but I was not aware that there are so many graphical possibilities. Thank you

[@PKAnExcelExpert]

Thanks Rob for your valuable feedback

[@zenildoluizabreu4959]

You are very creative, congratulations

[@RajKumar-qn2su]

Your all video is amazing 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@olusolao]

This is the best among others. Great creativity and excellent use of excel skill.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@Gayatri204]

Thank you sir, your knowledge is awesome.

[@PKAnExcelExpert]

My pleasure

[@TerrY9048]

Good info and many thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chandanlimma3443]

You are always amazing sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mns1965]

With reference to your bubble chart tutorial, when I insert the bubble chart, I am not getting the + sign, edit sign and filter sign, right next to the chart. So, I am when I double click the Y axis, the format axis options are not coming as seen in your video (time 2:35) and also error bars are not coming. Awaiting your feedback.

[@keyurpandya8353]

Really excellent work ☺

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pandharinathjoshi6565]

Great sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AntonioSilva-pq3zn]

TOP ...

[@PKAnExcelExpert]

Thanks

[@pointjabber]

Great stuff. this is really useful instead of a usual bubble chart when the bubbles overlap. Would you know how we can do this with Javascript?

[@PKAnExcelExpert]

Thanks for your valuable feedback. I don't know how we can do this in Javascript

[@rajeshchoudhary2520]

Nice video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sasavienne]

How do you get these great ideas?

[@younessloukili4203]

Thank you so much

[@PKAnExcelExpert]

Thanks for watching

[@Lovesv29]

Good Video

[@srsandeepsinghnegi]

very nice video.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SSDivineschool]

exellent...

[@PKAnExcelExpert]

Thanks

[@magorzatagaik2440]

Hello PK - you are not an excel expert - you are excel MASTER :) Your films are very helpful. Is it possible for you to prepare graph like "Spiders falls down on the lines"? For example we have 12 spiders that represents 12 months, and they start from the top, and if the spider value is bigger - spiders falls down on the line more I try to do this by myself but your version will be for sure more profesional. Thank you in advance.

[@PKAnExcelExpert]

Hi Małgorzata, Thanks for nice words. This is great idea. I will definitely try to make such graph. Thanks for watching and sharing your valuable feedback.

[@magorzatagaik2440]

Hi PK, Thank you. I have more ideas for the oryginally graphs. If you are interested I can write to you my ideas, maybe will be possible for you to prepare them?

[@PKAnExcelExpert]

Hi Małgorzata, It will my pleasure. Please share your great ideas. Thanks for your support.

[@magorzatagaik2440]

Hi PK, Few exaples for the begining: "Cake with the candles" - that many candles on the cake as is value for present month. "Weights chart" - every value on the chart is weights paint but when value is bigger the weight is also bigger. Chart for 12 month. ""Weighing pan" - compare of two values on weighing pan. "Horse racing" - comparison of sales value with few sales guys - shown as a horse racing (winner is first to the finish line, middle in the middle and last little form start line) "Scratched off lines" - something like four vertical lines scratched with fifth line. If present value is for example 58%, graph will show five full scratched lines and sixth part will have only 3 vertical lines (its difficult for me to explain this with the words) "Airplanes chart" - planes fly high or low depends on value they represent. Chart for 12 months. "Stars in the sky" - that many stars on the blue sky as big value is represents. "pearls necklace chart" - long necklace as big value is for a present month. "Months chart" - every bar on the chart for every month shows different picture suitable to this month (for example October will be Helloween pumpkin, December will be Santa Claus, January will be snowman, September will be school book, etc) "Train chart" - in windows on 12 wagons on the train shown value for every month. "Building chart" - something like "Train chart" but in vertical option - on 12 widnows in big building values represent every month. "Sun and clouds" - chart for 12 months. If value is bigger than in previous month bar is shown as a SUN, in other way bar is shown CLOUD. "Money" - Value on 100 dollar bill changes depend on value for present month. If present value is with the rest (55,15) rest is shown in the cents coins. "Phone or Calulator info" - value for present month is shown in the phone screen or calculator screen. "TV info" - - value for present month is shown on the TV news screen. That will be end at this moment. Sorry for my English. If something is not understanding for you please write to my private e-mail ([e-mail]) I will try to send you a look in the pictures of this what I mean.

[@leadedge7081]

This is excellent. However now I am unable to open document. Error unable to convert document. Is this still available please

[@PKAnExcelExpert]

Hi, I have just rechecked file is working properly. Which version of excel are you using? Send me your mail id. I will mail you this file.

[@syedikramullah1114]

Ok sir as u wish ....

[@renorayan]

well, I have succeeded to make my own balloon chart thanks to your pertinent tutorials. but I have found the problem that when the balloon = 100% it shows only half of it. how can solve this problem? I have tried to resize the both zones but in vain.

[@brianyoung4763]

change the axis from 0 to 1.2 and then it will show up to 120%

[@santoshsalgare7396]

Hi, thank you for value addition in our info graphics presentation. While making bubble diagram in Microsoft office 2010, i m unable to find series service level Y axis error bar. Please help me in that.

[@learningpower214]

I have a record of 1000 trucks and their stay time, now I want to see the number of trucks which will covered in different times

[@manivannan6068]

🫡 salute

[@PKAnExcelExpert]

Thanks