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? br br Here are the steps outlined in my video. br br Add Bar Chart br 1) Select the dataset br 2) Insert ~ Charts ~ Clustered Column br 3) Remove br - Title br - Legend br - Y-Axis br 4) Chart Element ~ Gridlines br 5) Select blue bars br 6) Chart Element ~ Data Labels br br Create Icons br 1) Insert ~ Illustrate ~ Icons br 2) Search for "Person" br 3) Select Male and Female icons br 4) Insert br 5) Male icon ~ Graphics Format ~ Graphics Fill br Select Brown br 6) Female icon ~ Graphics Format ~ Graphics Fill br Select Blue br 7) Select both icons br 8) Ctrl + C br 9) Ctrl + V br 10) Male icon ~ Graphics Format ~ Graphics Outline br Select Brown br Male icon ~ Graphics Format ~ Graphics Fill br No Fill br 11) Female icon ~ Graphics Format ~ Graphics Outline br Select Brown br Female icon ~ Graphics Format ~ Graphics Fill br No Fill br br Add Male Icon to Bar Chart br 1) Select Male (filled) br 2) Ctrl + C br 3) Click on Male bar twice (blue) br 4) Ctrl + V br 5) Select Male (no fill) br 6) Ctrl + C br 7) Click on Male bar twice (orange) br 8) Ctrl + V br br Put them together br 1) Select Male bar chart (filled) br 2) Right-click fill bar ~ Format Data Series br 3) Fill br 4) Stack and Scale with br 5) Repeat Step 1 to 4 for all bars. br 6) Click outside chart br 7) Click on any bar chart (once) br 8) Right-click fill bar ~ Format Data Series br 9) Series Overlap = 100 br 10) Gap Width = 0 br br Final Clean up br 1) Move Data Labels to the top of the bar chart br 2) Remove Data Label line br 3) Remove all symbols br br 🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗 br Male Female Ratio Infographics - Part 1 br br br Male Female Ratio Infographics - Part 2 br br br Male Female Ratio Infographics - Part 3 br br br br 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?, br br Check out my complete suite of Microsoft Excel Tips and Tricks.