I am trying to create a diverging bar chart with recruitment pipeline data. I would like to see for example, the volume and percentage of applications we receive from men and women and then follow that through to how many are shortlisted and then how many are offered jobs.
I have partially built it but I can't work out how to make my bars diverging, nor can I work out how to label my bars so that the percent split of each pipeline activity is showing.
I think I need to make the female count negative and then have each measure as a stacked bar chart - but I can't work out how to do it with my data as is.
Any help would be greatly appreciated!