Quick Male/Female Ratio and Waffle Chart in Excel

#WaffleChart #InfographicChart
Hello Friends,
In this video, you will learn how to create quick waffle chart using sequence function in Excel. We have also explained, how to create a Male and Female info-graphic chart.
Download the practice file from the below link:
www.pk-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcel...
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
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

[@nedlin7934]

Eye opening technique!

[@PKAnExcelExpert]

Thanks

[@luckypallu]

Amazing !!! I like the way you explain.

[@PKAnExcelExpert]

Most welcome

[@nadermounir8228]

Absolutely amazing. Thank you for sharing your knowledge with us :)

[@PKAnExcelExpert]

My pleasure!

[@MichaelBrown-lw9kz]

Wow. Yeah, you taught me a lot today, sir.

[@PKAnExcelExpert]

Thanks

[@dhuman8569]

This is incredible, thanks. Can you tell me why when I do the steps for the waffle chart, I select character 152 and 153 from Windings 2, but then it shows a different character on the sequence. When I look at the symbols code it is correct, but as soon as I enter it into the formula, it changes it.

[@kimyenchu]

Your channel is great. I love it. 😊

[@PKAnExcelExpert]

Glad you enjoy it!

[@datalab365]

Thank you.

[@PKAnExcelExpert]

Most welcome

[@temyraverdana6421]

This a very amazin lessons. Thanks a lot

[@PKAnExcelExpert]

Thanks

[@udaypratapsingh9967]

Thanks PK for sharing, very informative

[@PKAnExcelExpert]

So nice of you

[@fundancevlogswithtuktuk3835]

I want to know the pointer which u used in ur video,,,like yellow zoom pointer

[@78765710]

Pls make detailed vedio on inbound dashboard

[@Luciano_mp]

Nice work, i liked! Thank you!

[@PKAnExcelExpert]

Thanks a lot.

[@anhnhatnguyet4628]

Joining multiple excel files with multiple sheets/every file, the resulting data file is directly put into a single sheet (the files to be joined have the same structure, and the title starts from A1), how to use VBA?

[@mahansor8295]

👍👍 perfect

[@PKAnExcelExpert]

Thanks

[@towojuolusola725]

Which formula can i use if I'm using earlier versions of Microsoft Excel Because SORT, SEQUENCE etc are all Microsoft Excel 2019 version formulae

[@PKAnExcelExpert]

Use below formula: =(COLUMNS($A10:A$10)+10*(ROWS($A10:A$10)-1))/100 First fill right and fill up

[@towojuolusola725]

@@PKAnExcelExpert okay will give it a try and revert Thanks Pryiendra

[@78765710]

I need inbound dashboard within 1,2 days please

[@78765710]

Inbound dashboard please

[@khushboo1may]

Sir mujhe basic excel aata hai but mujhe Logic use karna nhi aata advance level excel me😭😭😭😭😭😭 what should I do?

[@nicoles.h.6640]

The Formula in the video does not work. The formula from a comment: (COLUMNS($A10:A$10)+10*(ROWS($A10:A$10)-1))/100 does work, but won´t work when I want to put symbols in it does not work again: =(COLUMNS($A10:B$10)+10*(ROWS($A10:B$10)-1))/10

[@gauravshukla46]

Your any paid course please give me link

[@nantachaiintaraagsorn6718]

I found a problem when set Male 100% /100% and female 100% /100%

[@temyraverdana6421]

I've been crazy with a graphic designer for more than a week. I hate graph 🙃