Info-graphics: Animated Hour Glass Chart in Excel

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • #HourGlassChart #AnimatedChart #Infographics
    Hello Friends,
    In this video you will learn how to create animated hour glass chart to display the KPI Metrics like-Service Level, Quality Score, Productivity etc.
    Please download this excel file from below given link:
    www.pk-anexcel...
    See our Excel Products:
    www.pk-anexcel...
    Visit to learn more:
    Chart and Visualizations: www.pk-anexcel...
    VBA Course: www.pk-anexcel...
    Download useful Templates: www.pk-anexcel...
    Dashboards: www.pk-anexcel...
    Watch the best info-graphics and dynamic charts from below link:
    • Dynamic Graphs
    Learn and free download best excel Dashboard template:
    • Excel Dashboards
    Learn Step by Step VBA:
    • VBA Tutorial
    Website:
    www.PK-AnExcel...
    Facebook:
    / pkan-excel-expert-9748...
    Telegram:
    t.me/joinchat/...
    Twitter:
    / priyendra_kumar
    Pinterest:
    / pkanexcelexpert
    Send me your queries on telegram:
    @PKanExcelExpert

Комментарии • 56

  • @AshishKumar-cw2so
    @AshishKumar-cw2so 5 лет назад +3

    Sir To be honest you are really expert in Excel

  • @JeffersonAMontoya
    @JeffersonAMontoya 5 лет назад +2

    Excellent, greetings from Colombia.

  • @charliearmour1628
    @charliearmour1628 2 года назад +1

    So very clever. Thank you for sharing.

  • @dennisharris144
    @dennisharris144 5 лет назад +1

    Really great video. This is one of my favorite channels. I learned Excel a LOOONNG time ago and now I have some catching up to do

  • @chandanlimma3443
    @chandanlimma3443 5 лет назад +2

    PK sir,
    You are always awesome.

  • @pabloaragoncalero8142
    @pabloaragoncalero8142 5 лет назад +2

    Excellent video sir! Thz for share!

  • @heikoheimrath7514
    @heikoheimrath7514 5 лет назад +2

    Super !!! Greetings from Germany

  • @snd2604
    @snd2604 5 лет назад +1

    Super ! Very good work . I like working in excel very much.

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 5 лет назад +2

    Thank you for this video

  • @hernanmendez8176
    @hernanmendez8176 5 лет назад +1

    Excellent!!

  • @patrickmccann2324
    @patrickmccann2324 5 лет назад +1

    Superb!!!

  • @MrChrisgapo
    @MrChrisgapo 5 лет назад +1

    Thank you Sir!

  • @cindysaranchuk5330
    @cindysaranchuk5330 Год назад

    Thank you for your excellent videos. I am really enjoying them. I am creating a dashboard and have used a few. I am wondering how to change this hour glass to show values instead of percentages. Is it possible?

    • @PKAnExcelExpert
      @PKAnExcelExpert  Год назад

      Yes you can! but you must define the maximum range like here in this case we have taken 100% is the maximum.

  • @everwelwisher
    @everwelwisher 5 лет назад

    wow .. very useful.

  • @joses.pacheco3069
    @joses.pacheco3069 5 лет назад +1

    Sensacional. Muito bom.

  • @wojciechwisniewski2510
    @wojciechwisniewski2510 5 лет назад

    great video thanks

  • @sharkseye9
    @sharkseye9 5 лет назад +2

    Excellent vid...but, I had an issue performing the macro automation on the other 2.

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 лет назад

      Please download the Excel file for better understanding. Download link has been given in videos discretion box.

  • @medkari
    @medkari 5 лет назад +1

    THANK'S

  • @ModernPindawale
    @ModernPindawale 5 лет назад +1

    Creative

  • @riaariarini8553
    @riaariarini8553 5 лет назад +1

    Thank you for your lesson
    But I want to ask question
    Why should we create the macro code if we can change the value of the cell manually to perform the animation automatically?

    • @conorleroy2362
      @conorleroy2362 3 года назад

      I dont mean to be so offtopic but does anyone know a method to log back into an instagram account??
      I was stupid lost my login password. I appreciate any assistance you can offer me!

    • @judsonbrendan657
      @judsonbrendan657 3 года назад

      @Conor Leroy instablaster :)

    • @conorleroy2362
      @conorleroy2362 3 года назад

      @Judson Brendan i really appreciate your reply. I found the site on google and im in the hacking process atm.
      I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.

    • @conorleroy2362
      @conorleroy2362 3 года назад

      @Judson Brendan it did the trick and I actually got access to my account again. Im so happy:D
      Thanks so much, you saved my account!

    • @judsonbrendan657
      @judsonbrendan657 3 года назад

      @Conor Leroy happy to help =)

  • @Drkalaamarab
    @Drkalaamarab 4 года назад +1

    Brilliant 🙂
    Any idea hot to web scrap via excel?

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад

      Thanks for your valuable feedback. I will definitely try to make such video very soon

  • @lakshminandankarri
    @lakshminandankarri 4 года назад +1

    sir, how to export Animated Hour Glass Chart to Userform??

  • @newlookak47
    @newlookak47 4 года назад

    I could not see the animation even after copying the code.
    Does the speed of the machine matter is hoe fast the animation is run?

  • @lynnebroughton7042
    @lynnebroughton7042 3 года назад

    Hi, could you write the code in a comment as the video is too quick, even when i try pausing, im missing something as the animation is not working on my sheet. Thanks for a great video

  • @talhausmani1446
    @talhausmani1446 11 месяцев назад

    Mera hourglass reverse m fill ho rha h
    I am using same vba code which you are using

  • @gentle2005phir
    @gentle2005phir 5 лет назад

    Gr8

  • @shaikhmoiz8789
    @shaikhmoiz8789 5 лет назад

    Sir I am using power point 2010. I am not able to use shape option if I use text colloum the shape option is desable

    • @shaikhasen
      @shaikhasen 5 лет назад

      It's default in build, check the tool bar and add it

  • @vivekmusafir4492
    @vivekmusafir4492 4 года назад +1

    What if percentage goes beyond 100%?

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 года назад +1

      Hi Vivek, This chart is for 100% or you can change the maximum value according to your requirements

    • @vivekmusafir4492
      @vivekmusafir4492 4 года назад

      @@PKAnExcelExpert Thank you so much for responding, however I have a situation where I have set a budget for certain things...and I want chart to showcase if I am exceeding that figure i.e. more than. 100%. Suppose I have budget for $100 Expenses...and expenditure goes beyond that..can you suggest something on this? Thank you...

  • @callmeat27
    @callmeat27 4 года назад

    animation is too fast to be observable