Male and Female Info-graphics in Excel

Hello Friends,
In this video you will learn how to create Male and Female Info-graphics Chart in Excel.
Please download this excel file from below given link:
www.pk-anexcel...
Learn Step by Step VBA:
• VBA Tutorial
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Website:
www.PK-AnExcel...
Facebook:
/ pkan-excel-expert-9748...
Pinterest:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
LinkedIn:
/ pk-anexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

[@delraydad7516]

I know its basically two years since you posted this video but THANK YOU VERY MUCH!!!!!!!! Excellent video with great explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@samirtamboli6834]

Generally i never comment on any video, but your creativity totally blown my mind. Thank you so much for this 😊

[@PKAnExcelExpert]

Thanks Samir, for your valuable feedback

[@faizkhan4840]

I really admire your Excel skills. You are truly gifted in Excel. 👍

[@PKAnExcelExpert]

Thank you very much!

[@gr8wh8orca53]

Excel must love you as much as you love Excel....learnt alot from you brother. Keep us Excellent 🙏🏼🤘

[@PKAnExcelExpert]

Thanks a lot🙏

[@prajapatirajesh452]

Aap to sir ekdam expert hai excel ki very very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@trader.fx1]

Hello, courtesy. Thank you for the excellent education. I designed this chart with your help. Is it possible to display the same chart as an image in the user form? Like when we display the chart in the user form.

[@Khunryijduy]

ขอบคุณมากครับ🎉❤❤❤❤❤❤❤❤🎉

[@PKAnExcelExpert]

Most welcome🙏

[@dilipinamdar5523]

nice tutorial ! thanks, it's useful!!!!!!!🙏

[@PKAnExcelExpert]

Thanks🙏

[@safiullah.amarkhail]

you are very professionsl. keep it up

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@user-hp5in5qc3s]

You are cool. Thanks from Ukraine

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@saxenarachit]

You are excellent in putting logics!!

[@PKAnExcelExpert]

Thanks

[@acousticalan]

excellent video bhai

[@PKAnExcelExpert]

Thanks

[@janezklun]

Great video, thank you for sharing, Best regards

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@barivp82]

PK ,
You are a specialist for excel

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rienthongw]

Thank you for sharing.It's very useful for my presentation.

[@santoshsapre]

Very nice Sir..Good work

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gloriapavez2342]

Thank you so much, I have learned a lot!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@achhajed]

This is quite interesting. Nice work and nice trick

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@narenraj2121]

very nice bro... such a knowledge full video thank you soo much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shivamsinghal2716]

You are amazing, Big thanks to you.......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@QuyenNguyen-is4lc]

Wonderful video. Thanks for all.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abirsarkar7075]

Thank you for this video.
I have a question, can we create a chart in PowerPoint using shapes and add animation to it but we want it link to an excel.
When we change the data in the excel file we want it to be reflected in the PowerPoint chart.
We make the chart using shapes.

[@backrw4835]

Thank you so much
Your videos are great.
Hugs from Brazi

[@cupheadcanal2conhecido159]

Muito bom seu trabalho... ( BRASIL)

[@hazemali382]

wow fantastic

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Xyour_starX]

Thanks pk, you are a really expert

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@keeleymazurkiewicz328]

I love this video. I am working on a project involving swine. Webdings doesn't have a pig. How would I be able to do use using an online stock image?

[@ThisisVall]

This is amazing! Thank you so much!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sosayeb]

very good tutorial, Thank you very much, keep on.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@studystac8522]

Amazing! Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@diannedrechsler4792]

What a great video. I'm thinking of how I could use this technique but with emoticons.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sudhirg7850]

Super 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@darshitchavda8264]

nice one

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@luckymadhoo]

Excellent !

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@NomanShahzaib]

Great work @PK. I am unable to open your website. Secondly, there is no link to your Google Drive. Can you please share file.

[@MohAboAbdo]

Thank you so much.

[@mvsvvs]

Thank you .🌺

[@NELUMINDRALAL]

Amazing Brother.. thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wildorjiron2393]

Wow very good.... Congratulation

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@AnhTuan-fv2kn]

great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yosephambawofficial7961]

Damn! ur good at it

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@topwalgadget703]

I am not getting pic to crop option in format. kindly suggest, i am using 2016 excel

[@seemaagiwal]

Hello Sir, your new student here. Have prepared 3 graphs from your videos in excel. They turned out too good. Still in the process of learning. Wanna to thank you personally. If possible can I have your email I. D. Please.
Thank you so much for making the things fancy and easy. Keep the good work going On.

[@nh45]

Great video PK, unfortunately bar doesn’t work when I put values between 84 - 99% works ok for other values. Please can you help?

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please change your axis as minimum 0 and maximum 1

[@nh45]

PK I set min max as you suggested for the blue data series not for the other one. Do I need to do this for both data series?

[@dharanim6570]

Hi PK im trying with Euro symbol in PPT. I cant able to combine them even though i have enabled the same from customised ribbon. After selecting both the pictures, combine shape is not highlighting to click

[@alirezamogharabi8733]

thanks, very useful.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@birendraprasadsah5517]

Great video!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@BD-nr8zx]

awesome....👌

[@Dan_Raja]

Why would anyone give thumbs down for this video?

[@PKAnExcelExpert]

Thanks for your valuable feedback and support

[@andrewkim9475]

Because a way too much commercials?

[@Puangocha]

great bro..thanks for your video..keep update...

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@09shirish]

nice tutorial ! thank, it's useful for me !

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@pa2happiness13]

💞👌

[@jdemitrivonkampfer]

Hi PK! I encountered a problem after making this. When i enter 84% to 99%, the bar doesn't display the correct fill. It's like the fill shows going back lower than 50%. How is this possible? Help please. I am using MS Excel 2013

[@md.moniruzzamanmonir2157]

Hi Brother
I didn't find merge shape option in MS Power Point 2007. I tried to add the option from Power Point Options but couldn't fin the options even in the all commands group. How can I do merging of shapes?

[@sohilmulla]

Hi Sir... M using office 10 so i didn't found the option for
merge the pictures in PowerPoint... Please advise

[@mdsaim475]

Very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SyedMuzammilMahasanShahi]

good one.

[@PKAnExcelExpert]

Thanks

[@DiamondDiamondHeart]

Your work is awesome but the background music is not necessary

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will take care of this in upcoming videos

[@Kvmunna]

Nice....brilliant

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@rohitjoshi2691]

how to merge/combine shape and text box in powerpoint 2010? any idea please.....

[@Compexcel]

THANKS..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajeshsinghjadham9899]

thanks sirji

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@susanb1024]

Thanks heaps

[@pedrogardaolaciregui5680]

PK, can i do it in .xs anda .ppt 2007? I don´t have the "merge shapes" en .ppt

[@Jeffer24171293]

Can I combine that's chart with data segmentation buttons?

[@abhishekapriya9204]

hi pk .... your video are gud ...BT the thing is am also facing the same issue when am giving 90-95% it is showing wrong graph it is suddenly comming down to 20%

[@PKAnExcelExpert]

Please check the axis it should be minimum as 0 and maximum as 1

[@FAS37910]

How to use slicer in for male female showing in this format

[@SmFacts190]

my excel 2007 has no merge shape what to do?

[@gaacharya123]

Awesome

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajashukla3033]

Hi PK, need your help... I am using excel 2010 and i am unable to merge the rectangle shape and the text (man). I have tried everything possible thing even googled but got stuck here... please assist...

[@sohilmulla]

I also facing same issue.... Please advise

[@srsandeepsinghnegi]

wonderful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@3am_dark_secret612]

WOW

[@PKAnExcelExpert]

Thanks

[@walidhozien4356]

Bravooooooooooooooooooooooooo

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@angkasawijaya7871]

Sir can you help how to setting Man and Female pict using Power Point 2010?
Thank you

[@vibhorbhargava7983]

HI.. Need to know if this can be done through Pivot Slicers

[@PKAnExcelExpert]

Just connect the chart with Table for pivot table then you can use slicers

[@mohdsameer2007]

I am unable to find these symbols 🙁

[@karthickrajalearn]

In 6m 01 sec I have doubt
Character border color balck i didn't get
It is not working in Msooffice 2007

[@shakirkhan2011]

How can I move this male/female graph to dashboard?

[@MawaliaSaab5125]

Thx sir

[@PKAnExcelExpert]

Thanks for watching

[@monojbanik3904]

Hi, could you please advise why the recipients are not able to see when I send this over an email. I have saved the file with .xlsb

[@monojbanik3904]

I have tried sending over email as well as through SharePoint

[@sahabsingh7455]

hi..
i show this video ,? i like this video .

[@bharathk03]

In Excel after cropping the picture, when i try to place it over the stacked column, the bar hides the picture. I tried 'Bring Front' and 'Bring Forward' options, but it did not work. Please suggest an solution

[@jonasvandendijk1175]

I have the same problem, someone a solution?

[@jonasvandendijk1175]

@bharathraj i've found the solution for the prob i guess. In powerpoint you need to go to fill and select fill with white ! (i had selected no fill) en if you then copy paste it as a picture to excel it works

[@AnujSingh-ue3fj]

How to work in ms Excel 10 version

[@harshitgupta8844]

Sir my textbox and shape are jot getting combined? What I do? Please help me sir

[@harshitgupta8844]

Sir I have PowerPoint 10

[@javedshaikh-cm1vs]

sir I made all but when I giving 99% it goes dawn automatically any solution plz revert it

[@PKAnExcelExpert]

Hi Javed,
Please check whether you have fixed the minimum value and maximum value for vertical axis. minimum should be 0 and maximum should be 100% or 1.
Please download this excel file from the link has been given in the video's description box for better understanding.

[@javedshaikh-cm1vs]

PK: An Excel Expert
I did it sir but facing same problem I tried 5 time , without hasitation I can't make this male female info graphics but the same problem facing give solution plz sir

[@bharatpokhriyal7185]

how to merge shapes in powerpoint 2010

[@jonasvandendijk1175]

ctrl+a

[@MunawerAhmed-lk6yn]

very good but wasting too much time to create.

[@amitdey170]

2010 nye male and female au ra ha

[@rohitjoshi9067]

how to merge/combine shape and text box in powerpoint 2010? any idea pleas.....

[@norangsingh8110]

how to merge shapes in powerpoint 2010

[@PKAnExcelExpert]

Merge shape is not available in PPT 2010