ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
1. Create a table with the data for 2 variables - Male and Female
4
2. Highlight the table and insert a chart -clustered column
5
3. Remove the Title, Legend and Y axis
6
MaleFemale
4. Click on the chart area to bring up the chart elements (+ sign at top right)
7
50%20%
5. Uncheck the box with gridlines
8
100%100%
6. Click on the blue bars and click on the chart elements.
9
7. Check the box on data labels.
10
11
8.Click on Insert icons
12
9. Search for "Person"
13
10. Select Male and Female Icons followed by insert.
14
11. Select the male icon and graphic format then select Graphic fill and blue color.
15
12. Select the female icon and graphic format then select Graphic fill and orange color.
16
13. Select both icons - press control button and click on both icons.
17
18
14. Press Control + C and then Control + V
19
15. Click on the copied Male icon and select Black for the outline and No fill under graphic format.
20
16. Click on the copied Female icon and select Black for the outline and No fill under graphic format.
21
22
17. Select Male (filled) and press Control +C
23
18. Click on the Male Blue bar twice (to ensure that only the Male Blue Bar is selected)
24
19. Press Control +V
25
20. Select Male (No fill) and press Control +C
26
21. Click on Male Orange Bar twice (to ensure that only the Male Orange Bar is selected)
27
22. Press Control +V
28
Repeat Steps 17 to 22 for Female
29
30
23. Click on the Male bar (filled) and right -click format data series.
31
24. Select fill Picture or texture and stack and scale with
32
25. Click on the Female bar (filled) and right-click format data series.
33
24. Select fill Picture or texture and stack and scale with
34
35
25. Click on any of the bar (once)
36
26. Right click format data series and select series overlap =100%, gap width =0%
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100