Innovation: Analog Clock in Excel (Pie + Doughnut Chart)

Поділитися
Вставка
  • Опубліковано 21 гру 2018
  • #AnalogClock #ExcelChart #VBA
    Hello Friends,
    In this video you will learn how to create an innovative and stunning Analog Clock in Excel. We have created this using Pie and Doughnut Chart.
    Please download this excel file from below given link:
    www.pk-anexcelexpert.com/anal...
    See our Excel Products:
    www.pk-anexcelexpert.com/prod...
    Visit to learn more:
    Chart and Visualizations: www.pk-anexcelexpert.com/cate...
    VBA Course: www.pk-anexcelexpert.com/vba/
    Download useful Templates: www.pk-anexcelexpert.com/cate...
    Dashboards: www.pk-anexcelexpert.com/exce...
    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-AnExcelExpert.com
    Facebook:
    / pkanexcelexpert
    Telegram:
    t.me/joinchat/AAAAAE2OnviiEk5...
    Twitter:
    / priyendra_kumar
    Pinterest:
    / pkanexcelexpert
    Send me your queries on telegram:
    @PKanExcelExpert

КОМЕНТАРІ • 51

  • @doublestarsystem
    @doublestarsystem Рік тому +2

    Good job,I send love and appreciation from Morocco...Thak you... I learnt a lot from this video.

  • @AjaySingh-np2si
    @AjaySingh-np2si Рік тому +2

    Thanks a lot sr👍
    This was really amazing 👍
    I appreciate your hard work 👍

  • @onkar8775
    @onkar8775 5 років тому +3

    You are really great sir, thanks for providing this valuable information.

  • @duncanwil
    @duncanwil 3 роки тому

    Very good, thank you.

  • @sasavienne
    @sasavienne 5 років тому +1

    Your videos are amazing. Thanks

  • @joses.pacheco3069
    @joses.pacheco3069 5 років тому +1

    Sensational!

  • @lowmeiyan2952
    @lowmeiyan2952 5 років тому +1

    Thanks for sharing. Really amazing

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 5 років тому +1

    Thanks for sharing this wonderful video

  • @jason_vegas5304
    @jason_vegas5304 5 років тому +1

    Awesome.. Thanks for sharing...

  • @kmanoj392
    @kmanoj392 7 місяців тому +1

    Nice

  • @nallanpradeep
    @nallanpradeep 5 років тому +1

    Appreciate your efforts

  • @akash723
    @akash723 5 років тому +1

    Awesome one.. just one to write can every video u upload have use also in the office

  • @Saatt79
    @Saatt79 5 років тому +1

    Awesome Innovation sir...as usual 👏👏👏👏👏👏

    • @PKAnExcelExpert
      @PKAnExcelExpert  5 років тому +1

      Thanks for your valuable feedback

    • @Saatt79
      @Saatt79 5 років тому +1

      PK: An Excel Expert Thanks 🙂 Can we have this analog split line IST EST and PST timings ⏰

  • @psmartinwilliamsbunjo223
    @psmartinwilliamsbunjo223 4 роки тому +1

    Thank You PK, I have a question. How can I display My Dashboard that has Slicers and Timeline on Sharepoint Excel Web access?

  • @GAURAVKUMAR-th5dz
    @GAURAVKUMAR-th5dz 5 років тому +1

    Suberb .....intresting....knowlagable

  • @kkarsd
    @kkarsd 5 років тому +1

    Great innovation ..

  • @alializadeh8195
    @alializadeh8195 3 місяці тому +1

    Thanx

  • @rajeshsinghjadham9899
    @rajeshsinghjadham9899 5 років тому +1

    Great sirji

  • @sultanrony4826
    @sultanrony4826 5 років тому +1

    any short cuts key to up or down in slicer?????

  • @colomboisdead153
    @colomboisdead153 4 роки тому

    I'm confused. What do you mean when you say "form mit"? I don't see any options in the menu for form mit. Do you mean to form it, as in "form the circle, form the colours"?

  • @sayedhussain5561
    @sayedhussain5561 4 роки тому +2

    sir i have created the code too but it is not working automatically. only with pressing it is working

  • @dude7741
    @dude7741 6 місяців тому

    i would request you can yu please make analog clock if i take time start from 9.30 as 12

  • @ThanhVuHai
    @ThanhVuHai 4 роки тому +1

    Hello, I have downloaded your file, but it does not work, can you tell me why?

  • @samratyadav850
    @samratyadav850 5 років тому +2

    Osm video sir... Next Excel animation par video bana

  • @rkexcel2686
    @rkexcel2686 5 років тому +1

    sir userform Mein kese show hogi yah please Bataye

  • @chandangoswami4810
    @chandangoswami4810 5 років тому +1

    nice sir.

  • @yelcabatana5372
    @yelcabatana5372 3 роки тому

    can this be done in google sheet?

  • @ThanhVuHai
    @ThanhVuHai 4 роки тому

    Sir, the problems that people have not been able to see cannot see you answer I do not understand ?

  • @ZulkarnainPane
    @ZulkarnainPane 3 роки тому

    mantab bro
    di chanel ku akan ku buat versi bahasa indonesia

  • @mdshahalam7180
    @mdshahalam7180 3 роки тому +1

    I have made it. My time is updating automatically, but graph not updating accordingly. please help me

    • @edwardclancy819
      @edwardclancy819 3 роки тому +1

      I have the same problem. Is there a setting that needs to be set?

  • @timoknuuttila3950
    @timoknuuttila3950 2 роки тому

    Is somebody else getting the same weirdness as I do: after 12:00 the hour arm starts reversing towards 11 until it hops to 1 o'clock. This seems to be an error in the formula calculating the hour arm, where the condition should be HOUR(NOW())>11 instead of HOUR(NOW())>12

    • @jimmielfitzgerald
      @jimmielfitzgerald 2 роки тому

      The correction needed to his formula is that the condition needs to be '>='. =IF(HOUR(NOW())>=12,HOUR(NOW())-12,HOUR(NOW())+(Minutes/60)