Balloon Chart in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 57

  • @grijalvaescobedo158
    @grijalvaescobedo158 2 ปีที่แล้ว +1

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  2 ปีที่แล้ว

      Gracias por sus valiosos comentarios.

  • @manivannan6068
    @manivannan6068 9 หลายเดือนก่อน +1

    Thanks

  • @jessijuniper7687
    @jessijuniper7687 5 ปีที่แล้ว +2

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 ปีที่แล้ว +1

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

  • @a2mtechnicalwissen54
    @a2mtechnicalwissen54 2 ปีที่แล้ว +1

    You are very great sir
    Your all video are very helpful

  • @RJG-Studios
    @RJG-Studios 6 ปีที่แล้ว +1

    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
      @PKAnExcelExpert  6 ปีที่แล้ว

      Thanks Rob for your valuable feedback

  • @olusolao
    @olusolao 7 ปีที่แล้ว +2

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  7 ปีที่แล้ว

      Thanks for watching and sharing your valuable feedback

  • @RajKumar-qn2su
    @RajKumar-qn2su 4 ปีที่แล้ว +1

    Your all video is amazing 👍

  • @Gayatri204
    @Gayatri204 4 ปีที่แล้ว +1

    Thank you sir, your knowledge is awesome.

  • @zenildoluizabreu4959
    @zenildoluizabreu4959 3 ปีที่แล้ว

    You are very creative, congratulations

  • @TerrY9048
    @TerrY9048 3 ปีที่แล้ว +1

    Good info and many thanks

  • @chandanlimma3443
    @chandanlimma3443 6 ปีที่แล้ว +1

    You are always amazing sir

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 3 ปีที่แล้ว +1

    Great sir

  • @mns1965
    @mns1965 6 ปีที่แล้ว

    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.

  • @AntonioSilva-pq3zn
    @AntonioSilva-pq3zn 2 ปีที่แล้ว

    TOP ...

  • @pointjabber
    @pointjabber 5 ปีที่แล้ว +1

    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
      @PKAnExcelExpert  5 ปีที่แล้ว

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

  • @rajeshchoudhary2520
    @rajeshchoudhary2520 5 ปีที่แล้ว +1

    Nice video

  • @keyurpandya8353
    @keyurpandya8353 6 ปีที่แล้ว

    Really excellent work ☺

  • @younessloukili4203
    @younessloukili4203 4 ปีที่แล้ว

    Thank you so much

  • @srsandeepsinghnegi
    @srsandeepsinghnegi 6 ปีที่แล้ว

    very nice video.

  • @syedikramullah1114
    @syedikramullah1114 7 ปีที่แล้ว

    Ok sir as u wish ....

  • @SSDivineschool
    @SSDivineschool 6 ปีที่แล้ว

    exellent...

  • @sasavienne
    @sasavienne 5 ปีที่แล้ว

    How do you get these great ideas?

  • @manivannan6068
    @manivannan6068 9 หลายเดือนก่อน +1

    🫡 salute

  • @santoshsalgare7396
    @santoshsalgare7396 6 ปีที่แล้ว

    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.

  • @renorayan
    @renorayan 6 ปีที่แล้ว

    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
      @brianyoung4763 4 ปีที่แล้ว

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

  • @magorzatagaik2440
    @magorzatagaik2440 7 ปีที่แล้ว

    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
      @PKAnExcelExpert  7 ปีที่แล้ว

      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
      @magorzatagaik2440 7 ปีที่แล้ว

      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
      @PKAnExcelExpert  7 ปีที่แล้ว

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

    • @magorzatagaik2440
      @magorzatagaik2440 7 ปีที่แล้ว

      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 (rgaik@wp.pl) I will try to send you a look in the pictures of this what I mean.

  • @leadedge7081
    @leadedge7081 6 ปีที่แล้ว

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

    • @PKAnExcelExpert
      @PKAnExcelExpert  6 ปีที่แล้ว

      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.

  • @learningpower214
    @learningpower214 6 ปีที่แล้ว

    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