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
