Dynamic chart for Top Selected Employees with GROUPBY and TAKE function

#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-anexcelexpert.com/dyna...
Subscribe our new KZread 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-anexcelexpert.com/pks-...
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...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

Пікірлер: 36

  • @Raj25145
    @Raj251452 ай бұрын

    Awesome report👍👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 ай бұрын

    Thanks

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 ай бұрын

    Thanks

  • @chinmayrj
    @chinmayrj3 ай бұрын

    Excellent 🔥

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 ай бұрын

    Thanks

  • @ashutoshpatel19
    @ashutoshpatel194 ай бұрын

    I always waiting your upcoming video

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 ай бұрын

    Thanks

  • @ashutoshpatel19
    @ashutoshpatel194 ай бұрын

    Your every video is dynamic to another person videos

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 ай бұрын

    Thanks

  • @mohamedhashem6927
    @mohamedhashem69275 ай бұрын

    Great 👍

  • @ICTNuggets
    @ICTNuggets5 ай бұрын

    Great video PK

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 ай бұрын

    Thanks

  • @nadermounir8228
    @nadermounir82285 ай бұрын

    Very nice Video 📹 👍 Thank u PK

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 ай бұрын

    Most welcome

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi5 ай бұрын

    Thanks for the share.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 ай бұрын

    Thanks for watching!

  • @naveenkarthik3305
    @naveenkarthik33055 ай бұрын

    Awesome 👌

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 ай бұрын

    Thanks 🤗

  • @pandharinathjoshi6565
    @pandharinathjoshi65655 ай бұрын

    Sir superb imagination sir💐💐💐🙏🙏🙏🙏

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 ай бұрын

    Thanks a lot

  • @ashutoshpatel19
    @ashutoshpatel194 ай бұрын

    Plz plz plz make power automate video

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 ай бұрын

    Will make soon

  • @ashutoshpatel19
    @ashutoshpatel194 ай бұрын

    Sir plz make power automate tutorial

  • @PKAnExcelExpert

    @PKAnExcelExpert

    4 ай бұрын

    Will create soon

  • @sumardjo
    @sumardjo5 ай бұрын

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

  • @tofikqureshi6507
    @tofikqureshi65075 ай бұрын

    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.

  • @Chenney-yp2fj
    @Chenney-yp2fj4 ай бұрын

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

  • @mujeebsarang7385
    @mujeebsarang73855 ай бұрын

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

  • @Jabirbinsidhiq786
    @Jabirbinsidhiq7864 ай бұрын

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

  • @yashshah_18
    @yashshah_185 ай бұрын

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

  • @quenbelliza2025
    @quenbelliza20255 ай бұрын

    Excel functions course plz ?

  • @PKAnExcelExpert

    @PKAnExcelExpert

    5 ай бұрын

    Will upload soon

  • @matlholelosaba4977
    @matlholelosaba49775 ай бұрын

    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

    5 ай бұрын

    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

    5 ай бұрын

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

  • @Chenney-yp2fj
    @Chenney-yp2fj4 ай бұрын

    Hi