How to make a Population Pyramid in Excel

[@cherryblossom4303]

I like how she's so enthusiastic about making a population pyramid

[@khadija_1b]

This video is so helpful I was growing frustrated and couldn’t get it right and then I came across your video I can’t thank you enough for uploading this

[@ProfBoggs]

I appreciate how short yet detailed is your video.
I would note that demographers usually divide the population in each cohort by the _total_ population, and not just the total male population or the total female population. However, it seems like most of the UA-cam videos and online Excel tutorials I've come across only divide each male cohort by the total male population and each female cohort by the total female population.

[@midorii77]

Thanks for this comment! I thought the tutorial was amazing, but with my skewed dataset (65% of my sample is male), my graph wasn't accurately displaying the data. Dividing each cohort by the total population was an easy fix.

[@ProfBoggs]

@@midorii77 You are welcome :)

[@davidnaturazi893]

So I learn that dividing a female and male population by the total population is more accurate. Thanks!

[@aejimun6710]

I'm an international student in australia, but honestly you saved my life from failing thanks a lot so much better than my tutors..

[@davidnaturazi893]

I was writing a field report and I was to present the population data of a certain ward, first I had to use pie chart instead, as I didn't know how to construct population pyramid in excel. Thanks for the tutorial now I know how to do it👏

[@mich.cachia]

You deserve a nobel prize - Thank you

[@ysatissantiago2574]

This really helped. Quick and easy to understand. Thank you!

[@rorys433]

how do you switch male and female around on the bottom in the legend so its the same way as the chart?

[@SarahWalls-i8y]

This was incredibly helpful, thank you so much!

[@christian8657]

Thank you! saved my demographics assignment

[@beatricewicker4065]

This video helped me so much and your accent and enthusiasm are precious :') Thank you

[@Pherron]

From the bottom of my heart, thank you :)

[@carlosbarragan3]

Bless your kind soul. This stressed-out students gives you many internet points

[@sascheto4124]

This is the most wholesome, yet so useful video I have ever seen!

[@911alps]

Ok wow 🤩 finally someone who explained this step by step that I was able to follow 🥰

[@soyelnish]

Amazing, and the exitement in her voice made me laugh during this boring task I have to do :)

[@Chris-rg1gx]

Thanks Kobe - very helpful! was able to create one for my uni assessment :)

[@dunthphu]

I'm working on an interview case and this is so useful. Thank you so much!

[@davidandjennyszabo1825]

Thanks very much Kobe, just what I was looking for

[@juliannekaminiel1794]

THANK YOU SO MUCH I've been trying to figure this out for 5 whole days

[@sriparnaGeoeditor]

Girl, you just saved me ❤️

[@Blackout45656]

very nicely structured and helpfull vid

[@emreozsalman9074]

Amazing work, detailed, and easy to understand.

[@nurnovilina]

thank you so much, this really help my assignment! I love your enthusiasm hahaha

[@khalidhaariye950]

Thank you very very very much. I was really struggling a lot on this. You made my life easier. God bless you Kobe. Please do more I just started following your channel.

[@hann4995]

Thank you for such a detailed and easy tutorial!

[@solotraveller2342]

Good video but I wish the narration was slower

[@winnifredeugeniaquartey]

Exactly step by step 😢

[@Themindlabmatrix]

Thank you so much! This is really helpful for my college

[@burgundy.red1655]

thank you so much! your enthusiasm helped me get through the stress while making my homework😂

[@lazybuilder4383]

When you said, ‘the number you wanted to convert’, what do you mean? Please help

[@markokovacevic8862]

Thanks a bunch! This was a super useful and quick way to do it.

[@deanaronelson3979]

Thank you soo much! You saved my project.

[@crisostomozeddimetriu1964]

I do appreciate your effort to teach, but when you are teaching something, don't skip or cut. Because some of your students might get confused if you skip something they are not aware of yet.

[@jasminegrados3700]

How did she select two rows at the same time?

[@jasminegrados3700]

Nevermind, you have to hold ctrl while selecting the rows.

[@thismightbedolly]

thanks queen this was suuuuuper helpful

[@zainabkhan2475]

I just watched one vid of yours and subscribed for u have so much clrearity

[@lovrodjuranec882]

Thanks for tutorial, really helped a bunch!

[@jejegaming-qd8he]

love your video man👍

[@peterkelly1665]

this has been so helpful thanks

[@HmaraPunjab]

Very Informative video for me because i am Statistics student

[@sleepyheadoutsho2656]

Hey Kobe. How do you show the percentages on the pyramid? And how do you get rid of the negative signs on the male side?

[@AdrianDanielGuard]

It says in the video towards the end

[@laibamughal639]

Amazing video this video helps me alot 😊 stay blessed ✨♥️♥️

[@cae13912]

at 1:40 when I drag down the percentages turn out saying #DIV/0! like what the hell is that supposed to mean

[@MarcusSmithus1345]

Don't think it's of much help now, but what it is doing is continuing down the line of your population column, so you'll need to manually input the correct equation

[@josephinebrittany2788]

So this worked really well. However when I did one side of a population the graph makes it look smaller than the other side even though they are similar numbers. One is 75,000 but the percentage became -25.00% and the other of 70,000 became 93.333% so the “positive” side is a loooot longer than the other side

[@lenfantcheri159]

Thank you... this was exactly what I needed..I'm doing happy cart wheels..lol👍

[@alextugumisirize6161]

you are a good teacher

[@baharemoradi1029]

It was very useful, thank you!

[@ardeiardei12]

"saying more in fewer words", nice video :D

[@Lukas0901]

Does any one know how to center the bar i can't manage to do it. Its always on the side

[@ItAintNecessarilySo]

Thank you so much! You have an incredible talent for teaching :)

[@gc111997]

Thank you for this easy tutorial :D

[@enriquehernandez-rodriguez1794]

Thank you so much for your video! I was checking other videos but you are the only one that explains really clear how to change the negative numbers :D Thank a lot!

[@zainabkhan2475]

Thanks a lot it really helped. Mercy.

[@pratyasheeojah6311]

Thank you it was helpful

[@iangitonga1252]

Thank you,
life-long skill

[@gabrielmattka1321]

Thank you, this was a really helpful video

[@Caster3D]

Hey noice channel vid

[@sophieward2919]

loved the video but how do you change the numbers on the side of the paragraph to be going up in intervals?

[@NWM-cv4zl]

Idk if you still need this or not, but you’ll have to change the format on the label by right clicking, choose number and then custom. Type: standard,standard on the format code bar and click add.

[@alm9707]

Great! You make it so easy to learn 👍🏻

[@aliciapwaites]

Thank you Kobe you saved me

[@sleepyearther270]

thank you so much ! this was so helpful

[@allabout1135]

Thanks, bor brillant viedeo. Technuque about number ---> percentage formating was sinmpe but so amazing. Hope tas mome day we will see more videos like this. Thank.

[@shafraiqbal7439]

wow, that was awesome...thank you very much

[@RenzoCaceresRossi]

Love it, thanks :)

[@spencerstubbins1063]

Wouldn't this only give the percentage of a population relative to the sex, not relative to all the people? Shouldn't the male and female populations be added together and then the percentage calculated from that total?

[@mohammedalkhayari4279]

Thank you very much ❤❤❤❤

[@keaabarquez2498]

this is so helpful. thanks!

[@Rebekahrg]

Beautiful - thanks!

[@sheikmohamedamanulaa3898]

Clear and concise

[@LataShastriBhajan]

nhi ban raha he konsa exeal use kr rahe ho ap

[@therealmate1767]

What app is this?

[@spaRKLES88604]

Thanks Kobe

[@EubertGabunas]

THANK YOU SO MUCH!

[@laurafetubola3793]

Thank you so much!

[@tribenily]

but when i drag down it shows '#DIV/0!'....please help

[@mariah9979]

Great work - thanks.

[@theisjoachim]

Brilliant!

[@sheilaachieng809]

Wow. Thankyou

[@missilesbarro]

Thank you!

[@bittumondal806]

THANK YOU MAM.

[@johnbellic1645]

Great, thanks.

[@jemimasnow4338]

Really great tutorial. BUT, you have male%=100 and female%=100. This is incorrect, as it doesn't accurately show the relative sizes of the male and female populations. You need male%+female%=100. So your denominator for each % should be the total population, not the population for that sex.

[@mikebenengtouncry3613]

thank you very helpful

[@lukanislol]

Thanks!:D

[@Data-xh9wh]

Thanks a lot!

[@lotusluv]

thanks so much

[@Sandiplife]

Thank you so much 👌

[@jetovpici]

simple and efficient, thank you!

[@miroslavtomes2495]

thank you!

[@ykBaffa]

I salute

[@maxxim3413]

THANKS

[@winthandar4413]

how to download?

[@titirnath252]

Thank you

[@hafeezshaikh8189]

Thankyouu

[@NoGo90]

Thanks!

[@lelanderrington6075]

kobeeeeeeeeee

[@nourismail6981]

Thank you very much, cutie! that helped me a lot

[@sam_sa09]

It doesn't work on an ipad

[@winnifredeugeniaquartey]

I don't get it 😅

[@shandongayrama4383]

Problem solved. :)