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 />https://youtube.com/shorts/XwCLcMd3krQ?feature=share <br /><br />Male Female Ratio Infographics - Part 2 <br />https://youtube.com/shorts/EXRDWMwi3rI?feature=share <br /><br />Male Female Ratio Infographics - Part 3 <br />https://youtube.com/shorts/8HaNHe8OBCo?feature=share <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. <br />https://www.youtube.com/@RabiGurungXybernetics/shorts <br />https://www.tiktok.com/@xybernetics247 <br />https://www.instagram.com/rabi.gurung247/ <br />https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/ <br />https://twitter.com/XyberneticsInc/media <br />https://www.reddit.com/r/Excel247/ <br />https://www.facebook.com/XyberneticsInc/reels/ <br /><br />#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypуВ╖ #exceltips #exceltricks
