Dynamic chart for Top Selected Employees with GROUPBY and TAKE function

Поділитися
Вставка
  • Опубліковано 3 жов 2024
  • #excelchart #excelformula #excelfunctions
    Hello friends,
    In this video, we have explained how to create a Dynamic chart for Top Selected Employees with GROUPBY and TAKE function.
    Download the practice file from below given link:
    www.pk-anexcel...
    Subscribe our new UA-cam Channel:
    / @neotechnavigators
    Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
    • Project Plan(Gantt Cha...
    Download our free Excel utility Tool and improve your productivity:
    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:
    / pkanexcelexpert
    Telegram:
    t.me/joinchat/...
    Pinterest:
    / pkanexcelexpert
    LinkedIn:
    / pk-anexcelexpert
    Twitter:
    / priyendra_kumar
    Instagram:
    / pkanexcelexpert
    Visit our Amazon Store
    www.amazon.in/...

КОМЕНТАРІ • 40

  • @mohammadsamii
    @mohammadsamii Місяць тому +1

    Very very informative

  • @Raj25145
    @Raj25145 5 місяців тому +1

    Awesome report👍👍

  • @chinmayrj
    @chinmayrj 6 місяців тому +1

    Excellent 🔥

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

    I always waiting your upcoming video

  • @ashutoshpatel19
    @ashutoshpatel19 7 місяців тому

    Your every video is dynamic to another person videos

  • @ICTNuggets
    @ICTNuggets 8 місяців тому +1

    Great video PK

  • @nadermounir8228
    @nadermounir8228 8 місяців тому +1

    Very nice Video 📹 👍 Thank u PK

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 8 місяців тому +1

    Sir superb imagination sir💐💐💐🙏🙏🙏🙏

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi 8 місяців тому +1

    Thanks for the share.

  • @naveenkarthik3305
    @naveenkarthik3305 8 місяців тому +1

    Awesome 👌

  • @adarshrao3775
    @adarshrao3775 13 днів тому

    After a long process I made this chart in excel 2010🎉

  • @mohamedhashem6927
    @mohamedhashem6927 8 місяців тому

    Great 👍

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

    Sir plz make power automate tutorial

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

    Plz plz plz make power automate video

  • @sumardjo
    @sumardjo 8 місяців тому

    Thanks for sample file
    but my excel not function Take and Groupby
    thanks for your information

  • @Chenney-yp2fj
    @Chenney-yp2fj 7 місяців тому

    Hi ok could you please create an excel for high ratings and low ratings for workers

  • @tofikqureshi6507
    @tofikqureshi6507 8 місяців тому +1

    Hello PK Pls help me
    I'm facing the one condition use Google sheet make pivot table need click pivot table showing data as same sheet not new sheet data visible same sheet pls❤help pk.

  • @mujeebsarang7385
    @mujeebsarang7385 8 місяців тому

    How can we achieve this without using group by function as same is available in Microsoft 365?

  • @matlholelosaba4977
    @matlholelosaba4977 8 місяців тому

    How can one make the Maximum Number in the form control to be dynamic? This will cater for increasing employees in the table. I also thought merging columns was being discouraged in favour of aligning central.

    • @saurabhrai3135
      @saurabhrai3135 8 місяців тому

      Instead of typing number you can give cell referencing while selecting min and max value for foam control icon. The reference cell can then be connected with some formula to get dynamic number like counta(unique(b:b)-1) or any other appropriate formula.

    • @PKAnExcelExpert
      @PKAnExcelExpert  8 місяців тому

      We can show limited number of employee on the chart like 10 or 15 max.

  • @yashshah_18
    @yashshah_18 8 місяців тому

    Sir how can I practice these functions?
    Because I cannot see

  • @Jabirbinsidhiq786
    @Jabirbinsidhiq786 7 місяців тому

    Groupby function is not available.. how can we get it

  • @quenbelliza2025
    @quenbelliza2025 8 місяців тому

    Excel functions course plz ?

  • @Chenney-yp2fj
    @Chenney-yp2fj 7 місяців тому

    Hi