How to make a Population Pyramid in Excel

[@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

[@cherryblossom4303]

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

[@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 TH-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👏

[@roxanaaa.mariaa]

may God bless you for what u just taught me

[@ysatissantiago2574]

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

[@mich.cachia]

You deserve a nobel prize - Thank you

[@SarahWalls-i8y]

This was incredibly helpful, thank you so much!

[@beatricewicker4065]

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

[@dunthphu]

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

[@juliannekaminiel1794]

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

[@911alps]

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

[@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.

[@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.

[@Themindlabmatrix]

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

[@Chris-rg1gx]

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

[@christian8657]

Thank you! saved my demographics assignment

[@sascheto4124]

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

[@burgundy.red1655]

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

[@Pherron]

From the bottom of my heart, thank you :)

[@nurnovilina]

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

[@davidandjennyszabo1825]

Thanks very much Kobe, just what I was looking for

[@emreozsalman9074]

Amazing work, detailed, and easy to understand.

[@sriparnaGeoeditor]

Girl, you just saved me ❤️

[@soyelnish]

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

[@hann4995]

Thank you for such a detailed and easy tutorial!

[@carlosbarragan3]

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

[@deanaronelson3979]

Thank you soo much! You saved my project.

[@markokovacevic8862]

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

[@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!

[@alextugumisirize6161]

you are a good teacher

[@lovrodjuranec882]

Thanks for tutorial, really helped a bunch!

[@Blackout45656]

very nicely structured and helpfull vid

[@peterkelly1665]

this has been so helpful thanks

[@laibamughal639]

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

[@lenfantcheri159]

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

[@HmaraPunjab]

Very Informative video for me because i am Statistics student

[@iangitonga1252]

Thank you,
life-long skill

[@ItAintNecessarilySo]

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

[@jejegaming-qd8he]

love your video man👍

[@thismightbedolly]

thanks queen this was suuuuuper helpful

[@zainabkhan2475]

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

[@mohammedalkhayari4279]

Thank you very much ❤❤❤❤

[@baharemoradi1029]

It was very useful, thank you!

[@gc111997]

Thank you for this easy tutorial :D

[@EubertGabunas]

THANK YOU SO MUCH!

[@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

[@gabrielmattka1321]

Thank you, this was a really helpful video

[@laurafetubola3793]

Thank you so much!

[@pratyasheeojah6311]

Thank you it was helpful

[@aliciapwaites]

Thank you Kobe you saved me

[@Rebekahrg]

Beautiful - thanks!

[@sleepyearther270]

thank you so much ! this was so helpful

[@sheikmohamedamanulaa3898]

Clear and concise

[@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.

[@zainabkhan2475]

Thanks a lot it really helped. Mercy.

[@theisjoachim]

Brilliant!

[@solotraveller2342]

Good video but I wish the narration was slower

[@littlemissy_nia]

Exactly step by step 😢

[@rorys433]

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

[@RenzoCaceresRossi]

Love it, thanks :)

[@alm9707]

Great! You make it so easy to learn 👍🏻

[@ardeiardei12]

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

[@keaabarquez2498]

this is so helpful. thanks!

[@bittumondal806]

THANK YOU MAM.

[@missilesbarro]

Thank you!

[@spaRKLES88604]

Thanks Kobe

[@shafraiqbal7439]

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

[@Caster3D]

Hey noice channel vid

[@johnbellic1645]

Great, thanks.

[@lotusluv]

thanks so much

[@Data-xh9wh]

Thanks a lot!

[@lazybuilder4383]

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

[@jasminegrados3700]

How did she select two rows at the same time?

[@jasminegrados3700]

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

[@maxxim3413]

THANKS

[@sheilaachieng809]

Wow. Thankyou

[@lukanislol]

Thanks!:D

[@Lukas0901]

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

[@mariah9979]

Great work - thanks.

[@gocpng4699]

City And Regional Planning Use (CREP)

[@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

[@therealmate1767]

What app is this?

[@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.

[@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

[@miroslavtomes2495]

thank you!

[@titirnath252]

Thank you

[@jetovpici]

simple and efficient, thank you!

[@ykBaffa]

I salute

[@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?

[@mikebenengtouncry3613]

thank you very helpful

[@Sandiplife]

Thank you so much 👌

[@NoGo90]

Thanks!

[@tribenily]

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

[@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.

[@nourismail6981]

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

[@LataShastriBhajan]

nhi ban raha he konsa exeal use kr rahe ho ap

[@hafeezshaikh8189]

Thankyouu

[@lelanderrington6075]

kobeeeeeeeeee

[@winthandar4413]

how to download?

[@M0nma09]

It doesn't work on an ipad