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
Awesome report👍👍
@PKAnExcelExpert
2 ай бұрын
Thanks
@PKAnExcelExpert
2 ай бұрын
Thanks
Excellent 🔥
@PKAnExcelExpert
3 ай бұрын
Thanks
I always waiting your upcoming video
@PKAnExcelExpert
4 ай бұрын
Thanks
Your every video is dynamic to another person videos
@PKAnExcelExpert
4 ай бұрын
Thanks
Great 👍
Great video PK
@PKAnExcelExpert
5 ай бұрын
Thanks
Very nice Video 📹 👍 Thank u PK
@PKAnExcelExpert
5 ай бұрын
Most welcome
Thanks for the share.
@PKAnExcelExpert
5 ай бұрын
Thanks for watching!
Awesome 👌
@PKAnExcelExpert
5 ай бұрын
Thanks 🤗
Sir superb imagination sir💐💐💐🙏🙏🙏🙏
@PKAnExcelExpert
5 ай бұрын
Thanks a lot
Plz plz plz make power automate video
@PKAnExcelExpert
4 ай бұрын
Will make soon
Sir plz make power automate tutorial
@PKAnExcelExpert
4 ай бұрын
Will create soon
Thanks for sample file but my excel not function Take and Groupby thanks for your information
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.
Hi ok could you please create an excel for high ratings and low ratings for workers
How can we achieve this without using group by function as same is available in Microsoft 365?
Groupby function is not available.. how can we get it
Sir how can I practice these functions? Because I cannot see
Excel functions course plz ?
@PKAnExcelExpert
5 ай бұрын
Will upload soon
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
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
5 ай бұрын
We can show limited number of employee on the chart like 10 or 15 max.
Hi