Learn how to create male female ratio infographics. This will also be answering question on how do I create a gender ratio in Excel or how do I create a gender column in Excel? This video also somewhat answered question to, how do I make a male female pie chart in excel? Or how do I make a comparative bar chart in Excel?
Here are the steps outlined in my video.
Add Bar Chart
1) Select the dataset
2) Insert ~ Charts ~ Clustered Column
3) Remove
- Title
- Legend
- Y-Axis
4) Chart Element ~ Gridlines
5) Select blue bars
6) Chart Element ~ Data Labels
Create Icons
1) Insert ~ Illustrate ~ Icons
2) Search for "Person"
3) Select Male and Female icons
4) Insert
5) Male icon ~ Graphics Format ~ Graphics Fill
Select Brown
6) Female icon ~ Graphics Format ~ Graphics Fill
Select Blue
7) Select both icons
8) Ctrl + C
9) Ctrl + V
10) Male icon ~ Graphics Format ~ Graphics Outline
Select Brown
Male icon ~ Graphics Format ~ Graphics Fill
No Fill
11) Female icon ~ Graphics Format ~ Graphics Outline
Select Brown
Female icon ~ Graphics Format ~ Graphics Fill
No Fill
Add Male Icon to Bar Chart
1) Select Male (filled)
2) Ctrl + C
3) Click on Male bar twice (blue)
4) Ctrl + V
5) Select Male (no fill)
6) Ctrl + C
7) Click on Male bar twice (orange)
8) Ctrl + V
Put them together
1) Select Male bar chart (filled)
2) Right-click fill bar ~ Format Data Series
3) Fill
4) Stack and Scale with
5) Repeat Step 1 to 4 for all bars.
6) Click outside chart
7) Click on any bar chart (once)
8) Right-click fill bar ~ Format Data Series
9) Series Overlap = 100%
10) Gap Width = 0%
Final Clean up
1) Move Data Labels to the top of the bar chart
2) Remove Data Label line
3) Remove all symbols
ЁЯФЧЁЯФЧ LINKS TO SIMILIAR VIDEOS ЁЯФЧЁЯФЧ
Male Female Ratio Infographics - Part 1
https://youtube.com/shorts/XwCLcMd3krQ?feature=share
Male Female Ratio Infographics - Part 2
https://youtube.com/shorts/EXRDWMwi3rI?feature=share
Male Female Ratio Infographics - Part 3
https://youtube.com/shorts/8HaNHe8OBCo?feature=share
Male Female Ratio Infographics,How do I create a gender ratio in Excel?,How do I create a gender column in Excel?,How do I make a male female pie chart in Excel?,How to make a comparative bar chart in Excel?,
Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@RabiGurungXybernetics/shorts
https://www.tiktok.com/@xybernetics247
https://www.instagram.com/rabi.gurung247/
https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/
https://twitter.com/XyberneticsInc/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/
#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypуВ╖ #exceltips #exceltricks
