Display data based on comparison of values to overall percentages
Hi all,
I have a requirement where I need to display data for terminations (in %) based on Gender for Rolling 12 and also compare them with the overall population (in numbers)
For example, In June 2021, if overall numbers are 2000 - Female and 1000 - male, their terminations should be displayed in percent values.
I'm trying to achieve this using a bar chart. Is there a better option to achieve this visually? Would scatter chart work? Which is better? thanks in advance!