Go to the Insert tab and select the icons to be used in the chart.
I suggest using a vector icon so that the fill color and outline color can be defined separately.
Format the icons as preferred through the Format tab
- Icon size
- Graphics outline
- Graphics fill – this color will dictate the color of the Filled series
Duplicate the icons and define the formatting for the Full data series.
An empty fill can be used with a thick outline.
Transfer full icons to the chart
Transfer the Full icons to the chart by clicking on the icon and pressing CTRL + C (or right-click and select Copy).
Click on the corresponding series on the chart.
Select a single series by double-clicking and then pressing CTRL + V to replace the column with the icon.
Make sure that a single series has been selected, or the entire series will be replaced with the icon.
Do the same for the remaining Full series.
To widen the icons, change the gap width.
Select the chart and go to the series properties.
There are two options to get there:
- Press CTRL + 1
- Right click on the series and select Format Data Series
Under Series Options, set Gap Width to 0%.
Transfer filled icons to the chart
Do the same to transfer the filled icons to the chart.
However, you will notice that the icon shrinks instead of retaining its full size.
To change this into a cut-off version depending on the value, go to the Format Series Options and under Fill Color, select the Stack and Scale with option.
Repeat this for the Male Filled series.