- Take sample data. Here we take 2 more columns for supporting calculation.
2. To create Male %, give the below formula and copy it down to the column. Use the =C2/$C$23 formula for Female %.
3. Select any cell of data then go to the ribbon, select Insert, and select your chart type from the chart group.
4. Select Chart type as 2-D Bar.
5. The chart looks below.
6. To change the category in reverse on the vertical axis, right-click on the axis and select Format Axis.
7. After that in the Axis Options give a checkmark on the ‘Categories in Reverse Order’ box.
8. To change the axis label position, right-click on the Axis and select Format Axis, in Format Axis select Axis Option and choose Labels. Here click Low in the Label Position.
9. To remove the horizontal axis, click on Axis and press Delete.
10. To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.
11. To change the gap width in the bar, right-click on the chart and select Format Data, in Format Data Series select Series Option and change the gap width to 0%.
12. Now we give a white outline in the bar to distinguish one bar from another. Select the bar, go to Format ribbon, and choose shape outline as white.
13. To change the color, select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.
14. Follow the same step to change the color of the other part of the chart. Select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.
15. Select the chart Title and write your appropriate Title.
16. The chart looks below.