Population Pyramid Chart from scratch in Excel

Get 80%+ OFF on my NEW Excel Financial Modeling & Business Analysis Online Course! www.udemy.com/...
Have you ever seen a population pyramid chart? In this video tutorial you are going to learn how to create an age pyramid excel chart with simple step-by-step instructions.​
🔥 Subscribe to my Channel ► bit.ly/1KWfq14
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
💎Check Out My Udemy Online Courses ►►►►►►►►►►
📌Excel Dashboards and Data Analysis Masterclass ► bit.ly/35lO8OK
📌Excel Macros & Excel VBA Programming for Beginners ► bit.ly/2D3Ipkw
📌Excel Power Query, Power Pivot, Power Map & DAX Masterclass ► bit.ly/2qwa2jB
📌Excel Shortcuts, Hacks & Tricks: 100+ Tips for Excel 2016 ► bit.ly/2pEMlW8
📌Microsoft Excel Charts, Graphs and Data Visualization ► bit.ly/2qyosQr
📌Python for Beginners: Learn Python in One Day ► bit.ly/2s1nUTy
📌Complete Gmail Course ► bit.ly/2QCaUxQ
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
🚩 Connect with me on social:
Facebook ► / mellontraining
My Blog ► www.mellontrain...
My Online Excel Courses ► www.udemy.com/...
Twitter ► / mellontraining
Linkedin ► gr.linkedin.com/in/andreasexadaktylos
RUclips channel ► / mellontraining
#excel #excelcharts

[@mellontrainingtutorials]

Join the FREE COURSE 💥 TOP 30 Excel Productivity Tips: bit.ly/3w8yclD

[@ronakpaul7044]

Hey, friend thank you for the instructions. I am a demographer whose daily job involves the above. Please note that when you create percentages you need to divide the population in each male or female age group by the total population. Diving the population in each male or female age group by the total male or female population respectively is an incorrect way.

[@mellontrainingtutorials]

Thank you Ronak Paul for your recommendations. I'll do my best to improve it!

[@IRVSound]

thank you so much! I have an exam and i really needed to know how to do this

[@mellontrainingtutorials]

You are very welcome Dazed!

[@FaceFace-kx1mi]

This literally saved my assignment, thank you.

[@mellontrainingtutorials]

Thank you Face Face for your kind words!

[@svenharjacek]

Nice video man, saved me for a school assignment!

[@mellontrainingtutorials]

Thank you svenharjacek for your kind words!

[@sukinadz9611]

THANKS A LOT! VERY EASY, I WASTED WHOLE DAY YESTERDAY FOR DOING THIS!

[@mellontrainingtutorials]

Thank you Sukina Dz for your kind words!

[@allabout1135]

Sir thank You so mutch, this video vas missing piece of puzle to get understanding this visual. This is what I was looking for. Thanks!

[@mellontrainingtutorials]

Thank you Aleksandrs Bebrišs for your kind words!

[@lubaleong9619]

Thank you! This really helped me with a geodmographic analysis report.

[@mellontrainingtutorials]

You are welcome!

[@thursowillett3208]

Muchas gracias señor

[@mellontrainingtutorials]

Thanks for watching Thurso Willett!

[@tekbahadurthapa4509]

I really learned from this video, one thing i need how can move the age group from left side to centre, please suggest me.

[@mellontrainingtutorials]

Thanks for watching Tek Bahadur Thapa!

[@Zo_Be]

thanks mate. Great tutorial. Love the (*-1) trick to move the values to the left hand side of the graph. - Cheers.

[@mellontrainingtutorials]

You are very welcome!!

[@opentube5962]

Thanks

[@mellontrainingtutorials]

Thanks for watching wesen!

[@trippertrooper5424]

Thank you very much, this was a very helpful video.

[@mellontrainingtutorials]

You are welcome!

[@Just_ya3ni]

Thanks man u saved me

[@mellontrainingtutorials]

Thanks for watching pher ryda!

[@junkwang-hee8173]

proportion in each age category for males and females should be calculated by the sum total of males and females for all ages

[@giannistsiropoulos4934]

thanx man u saved me .. but do u know how to merge 2 pyramids in one ?

[@uditachatterjee]

Thanks a lot, this has been very helpful.

[@mellontrainingtutorials]

You are welcome!

[@lubaleong9619]

From Census data

[@pristinadhakhwa6624]

Life saver. Thankyouuu

[@mellontrainingtutorials]

You are very welcome Pristina Dhakhwa!

[@royponce3425]

very helpful, thank you!

[@mellontrainingtutorials]

You are welcome!

[@TopTV-du6hs]

what happens when we already have the data in a percentage, is the formula still needed?

[@Siff16]

Thanks man

[@mellontrainingtutorials]

You are very welcome!

[@moflowmonem8179]

Isnt it possible to have both percentages as a positive value. It doest logic if it is negative. I know it is done to get two directions..but the value isnt correct

[@mellontrainingtutorials]

Hi there!
Great question! Yes it's possible to have both percentages as a positive value. Just follow the instructions:1) Right-click on the horizontal axis and select Format Axis2) From the dialog box on your right, from Number option click inside the Format Code and type: 0.0%_);0.0%3) Press Add and you are ready!Andreas

[@Fred-eg9sx]

the bars are offset

[@IM26C4UU]

love you

[@mellontrainingtutorials]

Glad you liked the video!

[@14GoOdLiFe]

Nice instruction .... but how can you do this with a pivot table ?

[@mellontrainingtutorials]

Hi there!
If you can manage to convert the pivot table to the exact format, then it's the same think. Keep in mind that Male% and Female% must have specific formulas.

[@vipanthakur1656]

Who to make moving it

[@zaviusfirerave]

Is there a way to make some of the bars thicker than the others?

[@mellontrainingtutorials]

+Zavius Firerave Hi there! No, you can't. You can change the thickness for all the bars, not some of them.

[@gede2787]

Can you put this on PowerPoint

[@PalashNandigame_chenger]

just copy and paste it to PowerPoint

[@mellontrainingtutorials]

Have you ever seen a population pyramid chart? In this video tutorial you are going to learn how to create an age pyramid excel chart with simple step-by-step instructions.​
Subscribe to my Channel ► bit.ly/1KWfq14