For females, we will make the values negative, so we can do so by multiplying with -1.
Now we need to add 2D clustered bar.
To make the plots compact set series overlap to 100% and gap width to 0.
Sometime we might want to overlay groups, in above case we plotted group1 (male and female). Now we can add group 2 by just adding data series. The calculations for group 2 are similar to group 1. Use select data source and add data series to add group2male and group2female.
You might want to add transparency to bars so that overlayed bars will not shadow to others.